4 Replies Latest reply on Jan 5, 2011 4:41 AM by 801568

    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.