11 Replies Latest reply: Dec 26, 2012 7:18 AM by EdStevens RSS

    While dropping the old undo tablespace we get an error

    Vicky C
      Hello friends ,

      i Cannot drop old undo tablespace. While dropping the old undo tablespace we get an error

      ERROR at line 1:
      ORA-01548: active rollback segment '_SYSSMU77$' found, terminate dropping
      tablespace


      SQL> select tablespace_name, status, segment_name from dba_rollback_segs where status != 'OFFLINE';

      TABLESPACE_NAME STATUS SEGMENT_NAME
      ------------------------------ ---------------- ------------------------------
      SYSTEM ONLINE SYSTEM
      APPS_UNDO NEEDS RECOVERY _SYSSMU77$



      Please help

      Thanks

      Edited by: Vicky C on Dec 23, 2012 9:23 AM