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

    Drop temporary tablespace

    user12100209
      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.