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 Linuxidc/oracle;
Connected.
Linuxidc@orcl11g>select * from Linuxidc;
NAME
------------------------------------------------------------
Linuxidc
--------------------------------------------------------------------------------