Wednesday 6 July 2011

ORA-1652: unable to extend temp segment by 128 in tablespace

I faced this problem.

You have to options to solve this; either by adding a new datafile to the Temp tablespace or create a new tablespace. In my case I did the second one. But don't forget to make the new created tablespace to be the default tablespace ALTER DATABASE DEFAULT  TEMPORARY TABLESPACE TEMP1;

No comments:

Post a Comment

Number of Visitors