counter1219 发表于 2013-04-26 17:52

oerr ora 01548错误码怎么解决啊，求解！

oracle@linux:~> oerr ora 01548
01548, 00000, "active rollback segment '%s' found, terminate dropping tablespace"
// *Cause: Tried to drop a tablespace that contains active rollback segment(s)
// *Action: Shutdown instances that use the active rollback segments in the
//         tablespace and then drop the tablespace


SQL> alter database open;

Database altered.

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_1351147975$' found, terminate
dropping tablespace


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_1351147975$' found, terminate
dropping tablespace

oracle@linux:~> oerr ora 01548
01548, 00000, "active rollback segment '%s' found, terminate dropping tablespace"
// *Cause: Tried to drop a tablespace that contains active rollback segment(s)
// *Action: Shutdown instances that use the active rollback segments in the
//         tablespace and then drop the tablespace
页: [1]
查看完整版本: oerr ora 01548错误码怎么解决啊，求解！