Oracle Fallback table Space cleanup

1. View the existing table space and find the fallback tablespace

SELECT * from dba_tablespaces WHERE contents= ' UNDO '

2. Create a new fallback tablespace

Create undo tablespace undo_rbs1 DataFile ' E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS02. DBF ' size 1000m;

3. Modify the system fallback tablespace to a new table space in 2

alter system set UNDO_TABLESPACE=UNDO_RBS1;

4. Remove the old fallback table space from the system

Drop tablespace undo_tbs1 including contents;

5. Delete the old fallback tablespace file in the operating system. If you do not allow deletion, you can restart the Oracle service before you delete it.

Oracle Fallback table Space cleanup