Change undo tablespace

on April 12, 2010 at 3:51 pm
Posted In: Oracle odds and ends (Cat)

Swap / change undo tablespace :

SQL> create undo tablespace UNDOTBS2 datafile ‘+data’ size 100M;

SQL> alter system set UNDO_TABLESPACE=UNDOTBS2;

SQL> drop tablespace UNDOTBS1 including contents and datafiles;

May have to wait for some transactions to be committed or rolled back.