SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string
SQL> select segment_name, tablespace_name, initial_extent,status from dba_rollback_segs;
SEGMENT_NAME TABLESPACE_NAME INITIAL_EXTENT
------------------------------ ------------------------------ --------------
STATUS
----------------
SYSTEM SYSTEM 57344
ONLINE
_SYSSMU1$ UNDOTBS1 131072
OFFLINE
_SYSSMU2$ UNDOTBS1 131072
OFFLINE
UNDOTBS1 SYSTEM 16384
OFFLINE
12 rows selected.
SQL> create undo tablespace UNDOTBS1
2 datafile '/oracle/ora90/oradata/orcl/undotbs01.dbf' size 10M;Tablespace created.
SQL> alter rollback segment UNDOTBS1 online;
Rollback segment altered.
No comments:
Post a Comment