今天有个同学碰到这个问题,帮他解决了下
它的undotbs1表空间有问题,想要删除它,碰到问题。
SQL> drop tablespace undotbs1 including contents and datafiles;
drop tablespace undotbs1 including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU1_557037162$' found, terminate
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU1_557037162$' found, terminate
dropping tablespace
数据文件的状态
SQL> select FILE#,STATUS,ENABLED,name from v$datafile;
FILE# STATUS ENABLED
---------- ------- ----------
NAME
--------------------------------------------------------------------------------
1 SYSTEM READ WRITE
/u01/app/oracle/oradata/PROD1/system01.dbf
2 ONLINE READ WRITE
/u01/app/oracle/oradata/PROD1/sysaux01.dbf
3
FILE# STATUS ENABLED
---------- ------- ----------
NAME
--------------------------------------------------------------------------------
1 SYSTEM READ WRITE
/u01/app/oracle/oradata/PROD1/system01.dbf
2 ONLINE READ WRITE
/u01/app/oracle/oradata/PROD1/sysaux01.dbf
3