bbed修改undo段状态(ORA-01578) - 数据库编程

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

bbed修改undo段状态(ORA-01578)(四)