8 Replies Latest reply: Oct 16, 2013 9:59 AM by rukbat RSS

    ORA-01548: active rollback segment

      Hi, I'm a junior DBA .

           I have 1 problem.

      I have create a new undo tablespace and set it to undo tablespace of instance


      ora11> alter system set

      undo_tablespace=undotbs2;


      but we can not drop the original one:


      ora11> drop tablespace undotbs1 including contents and datafiles; drop tablespace undotbs1 including contents and datafiles

      *

      ERROR at line 1: ORA-01548: active rollback segment ‘_SYSSMU2_6654314$’ found, terminate dropping tablespace



      how can solved this problem?