Preparing an object store database or table space for reuse

You can reuse the database or table space of a deleted object store for a new object store. Reuse allows you to retain settings such as next extent size, special user permissions, settings on the data files and transaction logs, and other customized settings.

To create an object store after following the preparation procedure in this topic, see Creating an object store.

Before you prepare a database for reuse, follow these steps:

  • Delete the object store that uses the database or table space before you attempt to reuse the database or table space for another object store. For information about deleting an object store, see Deleting an object store.
  • If a workflow system that shares the same database and schema is associated with the object store, delete all the connection points that are associated with the workflow system. The administration console automatically deletes the associated database constructs for the workflow system.
Note:  Preparing a database or a table space for reuse is an irreversible operation. The tables dropped as part of this procedure are permanently deleted. Do not drop tables unless you are certain that the tables belong to an object store that has been deleted. In particular, do not drop any table whose name begins with FNGCD unless you are also deleting a domain. (For more information, see Deleting a domain.) When you select tables and sequences to drop, be sure to select only database constructs that are owned by the schema associated with the deleted object store.