Set UNDO
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
- ORCL 10g ^
To Dynamically Set an UNDO Tablespace
- Initiate a Set Undo action against a tablespace. For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying the settings on the Set Undo Tablespace wizard before clicking Execute:
| Step | Functionality |
|---|---|
|
Action Options |
Displays the tablespace you selected to be set as an Undo tablespace. |
|
Dependencies |
Lists referring and referenced objects potentially impacted by the change. For details, see Dependencies. |
|
Preview |
Preview the DDL generated from your choices. For more information, see Preview. |
For information on the scheduling option, see Scheduling.