Setting the Datafile for a Smallfile Tablespace to Automatically Extend

Setting the Datafile for a Smallfile Tablespace to Automatically Extend
This section explains how 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:
a. Select Auto Extend.
b. 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.
c. For Maximum File Size, enter a value in KB, MB, GB, or TB, depending on
available storage.
4. Click OK.
A confirmation message appears
... zobacz całą notatkę