This discussion is archived
8 Replies Latest reply: Oct 16, 2013 7:33 AM by TSharma-Oracle RSS

ORA-01548: active rollback segment

Newbie
Currently Being Moderated

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?