Oracle备份与恢复案例

Oracle备份与恢复案例(12) FROM dba_rollback_segs;

SEGMENT_NAME TABLESPACE_NAME      STATUS

----------- ------ ------------------------------------

SYSTEM        SYSTEM               ONLINE

RBS0          RBS                  NEEDS RECOVERY

RBS1          RBS                   NEEDS RECOVERY

RBS2          RBS                  NEEDS RECOVERY

11、SQL>drop rollback segment rbs0;

重算段已丢弃。

    SQL>drop rollback segment rbs1;

重算段已丢弃。

    SQL>drop rollback segment rbs2;

重算段已丢弃。

12、SQL>select segment_name,tablespace_name,status