Drop temporary tablespace
Hello every body
I need to drop a temporary tablespace because it is not in use.
So first I tried to do ¨drop tablespace temp including contents and datafiles¨ but it spent many many time and I cancelled the sentence. Later I dropped the tempfile using alter database tempfile ¨path¨ drop including datafiles; and the tempfile was dropped successfully. But I see the tablespace yet available of course without the tempfile.
When I tried to drop the tablespace it takes many time and never finish. How can I drop this tablespace?
thank you a lot of in advance.