Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Temp tablespace full

CrazyAnieDec 9 2009 — edited Dec 7 2012

Hi All,

I am not able to execute any select queries contaning huge sort operation on my DB as I am getting the below mentioned error:

ORA-01652: unable to extend temp segment by 128 in tablespaces TEMP.

I can see that of all the 1200 gigs allocated to this tablespace, 0% are free. But even after logging out of that session and relogging, the TEMP tablespace remains at the same capacity. So, do i now need to bounce the database so as to free it?

Also, when i check the v$sort_segment and v$sort_usage views, i find both of them empty. Then why is not the space getting deallocated. Am in following the wrong trail? Please advice.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2013

Added on Dec 9 2009

#general-database-discussions

26 comments

55,042 views