1 2 Previous Next 17 Replies Latest reply: Jun 16, 2010 12:28 PM by 595435 RSS

    Drop Temp tablespace hangs...

    595435
      I have created a new TEMP tablespace and made it default TEMP one.

      Now I want to drop TEMP3 tablespace, because it has become fulll...
      when I drop it through EM, it hangs...
      - - - - - - - - - - - - -- - - - - - - - -- - - - -- - - - - - -- - - - - -- - - -

      Once a tablespace has been dropped, the objects and data in it will no longer be available. To recover them can be a time consuming process. Oracle recommends a backup before and after dropping a tablespace.

      Are you sure you want to delete Tablespace TEMP3?

      Delete associated datafiles from the OS
      --------------------------------------------
      When I checked at EM, there are locks too..

      SMON has locked the system
      ----------------------
      What should I do now?
        1 2 Previous Next