Database Administration for Specific Platforms › UNIX/Oracle Routine Procedures › Adjusting Database Size

Adjusting Database Size

As you increase the number of models in your encyclopedia you may need to increase the size of the tablespaces for the Encyclopedia database. The tablespaces you will need to increase are:

• iefsency_idx- Index Tablespace
• iefsency_tab- Application Table Tablespace

The simplest way to increase the size of a tablespace is to add a data file to the tablespace. Use the Oracle procedures for adding a data file.

If you prefer to maintain a single data file for a tablespace you will need to do the following:

Follow these steps:

1. Shut down the servers.
2. Back up the database. Use the Oracle Export utility.
3. Delete the existing data files (since you are changing sizes):

   Use the UNIX Remove command.

   For example: rm <datafile>

4. Recreate the tablespaces using the new values:

   Run the CSE server re-installation.

5. Initialize the database:

   Run the CSE server re-installation.

6. Restore your data:

   Use the Oracle Import utility.

Note: For more information, see the Configure a CSE Server Environment in the CA Gen Server Encyclopedia User Guide.