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 9i ^
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:
| 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. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.