undo tablespace 사이즈 변경

SQL> create undo tablespace "UNDOTBS" datafile '/oracle/KED/sapdata1/undotbs.dbf' SIZE 10M;
Tablespace created.


SQL> alter system set undo_tablespace=UNDOTBS;
System altered.


SQL> drop tablespace PSAPUNDO including contents and datafiles;
Tablespace dropped.


SQL> create undo tablespace "PSAPUNDO" datafile '/oracle/KED/sapdata1/undo_1/undo.data1' size 8192M;
Tablespace created.


SQL> alter system set undo_tablespace=PSAPUNDO;
System altered.


SQL> drop tablespace UNDOTBS including contents and datafiles;
Tablespace dropped.