Re: HELP ! ! ! temp tablespace

'GC' has almost certainly diagnosed your problem correctly. You have a 14Gb temp tablespace which grew out of your control.

When you restart the database, you will
probably see the SMON processes running
at 100% to clean up the mess of extents
created in that temporary tablespace.

7 hours is NOT extreme - the newsgroup
has had reports to 14 - 21 hours for cleaning up tablespaces with tens of thousands of freed extents. Just hang in there and wait.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



ahmed kashif wrote in message <9745b8$oc1$1_at_news.ccit.arizona.edu>...


>Howard,

>

>thanks for your help, but it still hangs on me when i try to drop the

>tablespace. i let it run for almost 7 hrs last night. and yes, when moved

>the datafile i did the way it should be i.e taking it offline first, alter

>database rename..., then os level move and then bring it back online. like

 i


>mentioned earlier, since it was soo frustating, i have already deleted the

>temp file from the file system. then i tried to drop the tablespace through

>'drop tablespace...' - made no difference. now i have _copied_ my new temp

>file to the place where my old temp was, and renamed it to as the older

 temp


>(tried to make control file fool), it didn't work either. any suggestions??

>do i sound too retarded?

>