From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

Set UNDO Tablespace dialog lets you dynamically set an UNDO tablespace if the tablespace is running in AUTO UNDO mode.

Platform Availability

To Dynamically Set an UNDO Tablespace

  1. Initiate a Set Undo action against a tablespace. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying the settings on the Set Undo Tablespace wizard:
Step Functionality

Action Options

Displays the tablespace you selected to be set as an Undo tablespace.


Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies.


Preview the DDL generated from your choices. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.