Setting the Datafile for a Smallfile Tablespace to Automatically Extend

You can use Oracle Enterprise Manager Database Express (EM Express) to set a datafile for a smallfile tablespace to automatically extend when it reaches its size limit. The following instructions assume that the datafile was previously not an autoextending datafile.

To set a datafile to automatically extend:

1. In EM Express, from the Storage menu, select Tablespaces.

   The Tablespaces page appears.

2. For a smallfile tablespace, select a datafile for which you want to enable autoextend, and then from the Actions menu, select Edit Auto Extend.

   The Auto Extend Setting of Datafile page appears.

3. Complete the following steps:

   1. Select Auto Extend.

   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, enter a value in KB, MB, GB, or TB, depending on available storage.

4. Click OK.

   A confirmation message appears.

5. You can perform these steps for all the datafiles in a smallfile tablespace to set all of the datafiles to automatically extend.