Changing the Undo Tablespace to a Fixed Size

You change the undo tablespace to a fixed size to prevent the tablespace from growing too large or to better support Oracle Flashback operations.

To change the undo tablespace to a fixed size:

1. On the Automatic Undo Management page, after determining the minimum required undo tablespace size, click Edit Undo Tablespace.

   The Edit Tablespace page appears, displaying the properties of the undo tablespace.

2. In the Datafiles section, click Edit.

   The Edit Datafile page appears.

3. In the File Size field, enter the computed minimum size for the undo tablespace.

   See "Computing the Minimum Undo Tablespace Size Using the Undo Advisor".

4. In the Storage section, deselect Automatically extend data file when full (AUTOEXTEND).

5. Click Continue.

   The Edit Tablespace page returns.

6. Click Apply.

   A confirmation message appears.