Oracle Shrink Undo Tablespace. Reclaiming space from undo tablespace is very simple. This occurs when you are creating a new database, and the instance is started in automatic.

The steps to accomplish the goal are: In oracle, undo size can be. Because the undo_tablespace initialization parameter is a dynamic parameter, the alter system set statement can be used to assign a new undo tablespace.