Creating a Tablespace

You can create additional tablespaces to store user data, so that not all data is stored in the USERS tablespace. The following are some reasons to create additional tablespaces:

• For certain users, groups of users, or applications, it may be convenient to keep all application data in a separate tablespace or set of tablespaces for backup and recovery or maintenance reasons. For example, suppose you must recover all application data from backup due to a hardware or software failure, and you want to perform an offline recovery. If the application data is kept in a separate tablespace, then you can take just that tablespace offline and recover it, without affecting the operation of other database applications.

• Some applications, such as those with large partitioned tables, may benefit from distributing data across multiple tablespaces. This approach allows the optimal use of the available storage because frequently accessed data can be placed on high performance disks, and infrequently retrieved data can be placed on less expensive storage.

To create a tablespace:

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. Do one of the following:

   1. To create a new tablespace, click Create (not shown in the screenshot).

   2. To create a tablespace that is similar to an existing tablespace, in the Select column, select the tablespace whose attributes you want to reproduce. In the Actions list, select Create Like and then click Go.

   The Create Tablespace page appears, showing the General subpage.

5. In the Name field, enter a name for the tablespace.

6. In the Extent Management section, select Locally Managed.

   See "Locally Managed Tablespaces".

7. In the Type section, select Permanent.

   See "Tablespace Types".

8. In the Status section, select Read Write.

   See "Tablespace Status".

9. In the Datafiles section, click Add to add one or more data files to the tablespace.

   The Add Datafile page appears.

   Note: If you select Use bigfile tablespace, then the tablespace can have only one data file. Bigfile tablespaces are used with very large databases that use Automatic Storage Management or other logical volume managers that support striping, RAID, and dynamically extensible logical volumes.

10. If the Storage Type is File System, then in the File Name field, enter a file name. In the File Directory and File Size fields, enter appropriate values for your data file location and initial size.

11. 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.

12. Click Continue.

    The Create Tablespace page returns.

13. (Optional) Toward the top of the page, click Storage to view the Storage subpage. Examine all of the default settings on this subpage.

    See the online Help for more information about these settings.

14. Click OK to add the tablespace.

    The Tablespaces page returns, showing the newly created tablespace.