There may be insufficient table space or temporary table space:

Insufficient table space create table space statement

alter tablespace Name of space to add add datafile 'address name + filename + 01 to differentiate' SIZE 10G AUTOEXTEND ON NEXT 2048M MAXSIZE UNLIMITED