SSMU14_3021863913$ 3
_SYSSMU15_444141832$ 3
_SYSSMU16_3035903491$ 3
_SYSSMU17_178842559$ 3
_SYSSMU18_2539622763$ 3
_SYSSMU19_3920348761$ 3
_SYSSMU20_3705739785$ 3
SYS@orcl11g>select name,status$ from undo$;
NAME STATUS$
------------------------------------------------------------ ----------
SYSTEM 3
_SYSSMU1_3780397527$ 1
_SYSSMU2_2232571081$ 1
_SYSSMU3_2097677531$ 1
_SYSSMU4_1152005954$ 1
_SYSSMU5_1527469038$ 1
_SYSSMU6_2443381498$ 1
_SYSSMU7_3286610060$ 1
_SYSSMU8_2012382730$ 1
_SYSSMU9_1424341975$ 1
_SYSSMU10_3550978943$ 1
_SYSSMU11_3909920883$ 3
_SYSSMU12_3182721254$ 3
_SYSSMU13_3717211136$ 3
_SYSSMU14_3021863913$ 3
_SYSSMU15_444141832$ 3
_SYSSMU16_3035903491$ 3
_SYSSMU17_178842559$ 3
_SYSSMU18_2539622763$ 3
_SYSSMU19_3920348761$ 3
_SYSSMU20_3705739785$ 3
21 rows selected.
重新启动数据库，发现offline的回滚段不存在：
SYS@orcl11g>col segment_name for a30;
SYS@orcl11g>col tablespace_name for a30;
SYS@orcl11g>select segment_name,tablespace_name,status from dba_rollback_segs;
SEGMENT_NAME TABLESPACE_NAME STATUS
------------------------------ ------------------------------ ------------------------------------------------------------
SYSTEM SYSTEM ONLINE
_SYSSMU20_3705739785$ UNDOTBS02 ONLINE
_SYSSMU19_3920348761$ UNDOTBS02 ONLINE
_SYSSMU18_2539622763$ UNDOTBS02 ONLINE
_SYSSMU17_178842559$ UNDOTBS02 ONLINE
_SYSSMU16_3035903491$ UNDOTBS02 ONLINE
_SYSSMU15_444141832$ UNDOTBS02 ONLINE
_SYSSMU14_3021863913$ UNDOTBS02 ONLINE
_SYSSMU13_3717211136$ UNDOTBS02 ONLINE
_SYSSMU12_3182721254$ UNDOTBS02 ONLINE
_SYSSMU11_3909920883$ UNDOTBS02 ONLINE
这时候我们来查看该表：
SYS@orcl11g>conn zbdba/oracle;
Connected.
ZBDBA@orcl11g>select * from zbdba;
NAME
------------------------------------------------------------
zbbda