Re: HELP ! ! ! temp tablespace

guys, i think you were right. it's been ~22 hours now since i issued drop tablespace command, and it is still executing, but, since i had the listener down and nobody has ever connected since, i can see continous log switching in my bdump/alert*.log and a huge accumulation of .arc files in my /arc directory which something i going on. i am goona let it run forever, now, and i dont care how long it will take. thanks for the help.

--


Thanks,

ahmed

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:982927632.10850.1.nnrp-10.9e984b29_at_news.demon.co.uk...


'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?

>