Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> HELP ! ! ! temp tablespace
my temp (temporary) tablespace grew to ~14g (dont know why it was set to unlimited?) - ended up taking all the disk space. I moved it to another disk and brought it online, but then it wouldn't let me shutdown the database with the exception of shutdown abort. i tried to drop it with drop tablespace command, but it always seemed like it hung the database. i even let it go for hours - no luck. then i created a new tablespace 'temp2', and made that tablespace the temporary tablespace for all the users. then i shutdown (abort) the database and removed that sucker from the filesystem. brought the database up with no problem. then i tried again to drop it throught drop tablespace, but it still does the same - hang the database on me.
i still can see that tablespace in dba_tablespaces, and i still can't shutdown normal or immediate. please HELP!!!
-- Thanks, ahmedReceived on Wed Feb 21 2001 - 18:15:53 CST
![]() |
![]() |