Setting a Tablespace to Automatically Extend

This section explains how to set a tablespace to automatically extend when it reaches its size limit. The following instructions assume that the tablespace was previously not an autoextending tablespace.

To set a tablespace to automatically extend:

1. Go to the Database Home page.

   See "Accessing the Database Home Page".

2. At the top of the page, click Server to view the Server subpage.

3. In the Storage section, click Tablespaces.

   The Tablespaces page appears.

4. Select the tablespace for which you want to enable autoextend, and then click Edit.

   The Edit Tablespace page appears.

5. Select the first data file associated with the tablespace, and then click Edit.

   The Edit Datafile page appears.

6. In the Storage section, complete the following steps:

   1. Select Automatically extend data file when full (AUTOEXTEND).

   2. Set a suitable increment, such as 10 MB.

      This is the amount of disk space that is added to the data file when it needs more storage space.

   3. For Maximum File Size, do one of the following, depending on available storage:

      • Select Unlimited to permit the file to increase without limits.

      • Select Value, and then enter a value in KB, MB, GB, or TB.

7. Click Continue.

   The Edit Tablespace page returns.

8. Repeat Step 5 through Step 7 for each additional data file associated with the tablespace.

9. Click Apply.

   A confirmation message appears.