When Undo Tablespace Is Cleared?

The UNDO tablespace works as follows: * The UNDO records are not deleted when they are expired. They stay and are overwritten only when a new UNDO record needs to be written and there is no free space. Thus, it is normal for UNDOTBS1 to appear at 99% full.

Can we clear undo tablespace?

Deleting an unused oracle UNDO tablespace is similar to dropping any other tablespace. If you have multiple datafiles associated with an UNDO tablespace, delete those first. First, get a list of all the datafile for your UNDO tablespace. select file_name from dba_data_files where tablespace_name = 'UNDOTBS';

What happens if undo tablespace is corrupted?

If the Oracle UNDO table space is corrupted, it may be possible to get the error as follows. When UNDO segments corrupted, the following should be done: The undo_management parameter must be MANUAL. A new UNDO tablespace must be created.