Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Changing TEMP tablespace from type PERMANENT to type TEMPORARY
On an Oracle 8.0.5. database, someone made the TEMP tablespace to be type PERMANENT. I'd like to change it to type TEMPORARY. Would I need to take the database down and put it into mount mode to issue an alter tablespace command on it?
I queried dba_segments for the tablespace in question, and sure enough all the segments in it are owned by SYS and are of type TEMPORARY; so no one's storing anything else but temporary segments in it.
Thanks very much.
Sent via Deja.com
http://www.deja.com/
Received on Tue Feb 06 2001 - 14:29:33 CST