MOVE UNDO TABLESPACE

3 Jan

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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: