Reuse object store databases

If an object store is no longer in use and you plan to delete it, you can reuse the object store's database (Microsoft SQL Server, DB2) or table space (Oracle) with a new object store. By reusing an existing database or table space, you can retain and use the customized settings created for the database or table space—such as the next extent size, special user permissions, or settings on the data files and transaction logs—rather than configuring a new database or table space.

CAUTION  Dropping the User tables permanently deletes these tables and all the data they contain from the object store database. Drop the User tables only if you are certain that the data they contain is no longer needed. If the GCD database is co-located with an object store database (note that this is not recommended for production systems), be sure to not drop the FNGCD and FNGCD_ADDON tables. These tables store the domain configuration information and dropping these tables require you to re-create the domain.

To drop the object store User tables from a Microsoft SQL Server database

  1. Delete the object store that uses this database in Content Engine Enterprise Manager.
  2. Connect to the object store database in Microsoft SQL Server Enterprise Manager.
  3. Select the Tables icon in the right pane.
  4. Select and right-click on all of the User tables in the right pane. The User tables are identified by the term "User" in the Type column.
  5. Select Delete from the menu.
  6. On the Drop Objects dialog, click Drop All. SQL Server deletes the tables.

To drop the object store User tables from an Oracle table space

  1. Delete the object store that uses this table space in Content Engine Enterprise Manager.
  2. Start Oracle SQL Plus.
  3. Drop the Content Engine user account for the table space you want to reuse. Be sure to use the CASCADE option. For example:

    DROP USER <user_name> CASCADE
  4. Create a new user account for the table space. Use the following script as a guide for the privileges the new user account should have. Replace <user_name> and <password> with the Content Engine user account information and replace <table_space> with the name of the table space you are reusing.

    DROP USER <user_name> CASCADE;
    CREATE USER <user_name>
    IDENTIFIED BY <password>
    DEFAULT TABLESPACE <primary_table_space>
    QUOTA UNLIMITED ON <primary_table_space>
    TEMPORARY TABLESPACE <temp_table_space>
    QUOTA UNLIMITED ON <temp_table_space>;
    GRANT CREATE SESSION TO <user_name>;
    GRANT CREATE TABLE TO <user_name>;
    GRANT CREATE SEQUENCE TO <user_name>;

To drop the object store User tables from a DB2 database

  1. Delete the object store that uses this database in Content Engine Enterprise Manager.
  2. Connect to the object store database in IBM Control Center.
  3. Expand the object store database node and select the Tables folder in the left pane.
  4. Select the Tablespace column to sort this list of tables in the right pane.
  5. Select the tables associated with the object store. Do not select any tables in the SYSCATSPACE and SYSTOOLSPACE table spaces.
  6. Right-click to and select Drop to drop the selected tables.