not able to drop temporary tablespace 8.1.7

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




Oracle LazyDBA home page