1. periksa parameter UNDO
SQL> show parameter undo
NAME TYPE VALUE
———————————— ———– ——————————
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS4
2. CREATE UNDO TABLESPACE baru
SQL> CREATE UNDO TABLESPACE UNDOTBS4B DATAFILE
‘+DATA2/rac/datafile/undotbs4b.dbf’ SIZE 23325M AUTOEXTEND ON NEXT 25M MAXSIZE UNLIMITED
ONLINE
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON;
3. Mengubah parameter UNDO ke UNDO baru
SQL> alter system set undo_tablespace=UNDOTBS4B SID=’rac4′;
4. periksa parameter UNDO
SQL> show parameter undo
NAME TYPE VALUE
———————————— ———– —————————–
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS4B
5. delete TABLESPACE UNDO lama
SQL> drop tablespace UNDOTBS4 including contents;
Tags: MOVE UNDO TABLESPACE, RENAME UNDO TABLESPACE, UNDO, UNDO TABLESPACE
setijoagus
