Hi Friends,

I need to alter my temp tablespace so that it is temporary instead of permanent.

At the moment I cannot alter the tablespace to temporary becasue 11Mb is being used up.

I want to drop the objects currently inside temp tablepspace but don't know where to find them.

I queried dba_segments but it tells me that there is nothing in TEMP Tablespace. Is this becasue some PERMANENT Objetcs are already in there ?

Please tell me how to drop current objects in Temp Tablespace so that I can make the tablespace Temporary.

Also.... Does anybody know the reason or scenarios for defining the Temp tablespace as permanent. I know that a permanent tablespace leaves objects in there until they are dropped but I don't know why you would ever need to to define a temp tablespace as permanent, especially as it is only used to sort data when sort_area in PGA is full - I would expect it to always be dynamic dropping and creating objects whenever necessary.

Thanks

Suresh