Set UNDO
Go Up to [[Available object actions by DBMS{{#if:||{{{2}}}}}]]
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.
