Create a new one, alter all users to default to it and then drop next
time you restart db

-----Original Message-----
From: Ranganath H M
[mailto:oracledba-ezmlmshield-x58667544.[Email address protected]
Sent: Wednesday, August 02, 2006 1:16 AM
To: LazyDBA Discussion
Subject: not able to drop temporary tablespace 8.1.7

Hi all,
I am not able to drop temporary tablespace in 8.1.7 it is 20gb with 0%
free space.
I issued drop tablespace tablespace_name including contents.It just
hanged up for 12 hrs.
Is there any way to drop and reclaim the space.

Thanks,
Ranga





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html





Oracle LazyDBA home page