Fine Beautiful Tips About How To Clean Undo Tablespace

Sql> drop tablespace undo_rbs0 including contents;

How to clean undo tablespace. The following statement switches to a new undo tablespace: Sql> select tablespace_name, status, sum(blocks) * 8192/1024/1024/1024 gb from dba_undo_extents group by tablespace_name, status; Sql > select tablespace_name tablespace, status, sum (bytes) / 1024 / 1024 sum_in_mb, count (*) counts from dba_undo_extents group by tablespace_name, status order.

Then you have 3599mb free to use on undo without need to expand the undo_tablespace. Create a new undo tablespace as : The following statement effectively switches to a new undo tablespace:

Sql> create undo tablespace undotbs2 datafile sql> '/exlibris1/oradata/aleph20/aleph20_undotbs101.dbf' size 4g; Sql> select status,segment_name from dba_rollback_segs where status not in (offline') and tablespace_name= [undo tablespace to be dropped]; Assuming undotbs_01 is the current undo tablespace, after.

Assuming undotbs_01 is the current undo tablespace,. Undo tablespace ‘%s’ is currently in use. First, get a list of all the datafile for your undo tablespace.

Alter system set undo_tablespace = undotbs_02; Alter system set undo_tablespace = undotbs_02; 1) create a new undo tablespace 'undotbs2' 2) alter system set undo_tablespace=undotbs2 3) wait until all pending transactions using the old undo.

Sql> alter table wrh$_sqltext move lob (sql_text) store as tablespace sysaux; The dbms_undo_adv package provides some excellent feedback to help determine the best value for the undo_retention parameter: From a sql*plus session connected as sysdba perform the move operation as follows: