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

Suresh wrote:

>When I deleted the tables through drop table command the tablespace did
>not shrink, do I have to manually shrink the tablespace?

Since Oracle decides where to put segments within the tablespace, it is possible (likely, even) that it might create something near the end of the tablespace. As long as something is there, Oracle won't let you shrink the tablespace below it.

You can either have a wonderful learning experience figuring out scripts to tell you where the segments are, or you can use OEM to show you a "tablespace map" for an informative graphic (in 9i, not in EM, I've been told it comes back in 10gR2 but haven't checked). I'm normally a strong advocate of scripting, but this is one big exception.  Under the Instance --> Storage --> Tablespaces --> right click on tablespace name. You can also use the GUI to resize the tablespace.

Also see this:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:5549302357655 and
http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=267888.1

jg

--
@home.com is bogus.
http://www.cnn.com/2005/SHOWBIZ/Movies/10/10/aardman.fire/index.html