Database Administration for Specific Platforms › Oracle/Windows 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 following are the tablespaces you will need to increase:

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

Follow these steps:

1. Shut down the servers.
2. Back up the database:

   Use the Oracle Export utility. Follow the instructions in your Oracle Documentation.

3. Delete the existing data files (since you are changing sizes):

   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 Client Server Encyclopedia User Guide.