Documentation Center

Creating an Oracle Content Data Store database manually

Create your Oracle Content Data Store database manually by running the database scripts provided. In a demo or test environment, you can choose to create the State Store in the same database, by creating the State Store database tables as well. In a production environment, you can choose to create the State Store in its own database instead (for example, to improve performance), by running the State Store table creation commands separately.

Procedure

  1. Access your SDL Web installation media.
  2. In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Web administrator (defaults to TRIDION_SYS):
    • CD_BROKER_CREATE_USER.sql
    The script creates a new user (schema owner).
  3. In the Database\Scripts\Oracle\Shared\83\ folder, run the following script as the newly created user (schema owner):
    • TCM_SYSTEM.sql
    The script creates a new user (schema owner).
  4. In the Database\Scripts\Oracle\Create\ folder, run the following scripts as the newly created user (schema owner):
    • CD_BROKER_TABLES.sql
    • CD_BROKER_CONSTRAINTS.sql
    • CD_BROKER_INDEXES.sql
    • CD_WAI_TABLES.sql
    • CD_WAI_SEQUENCES.sql
    • CD_WAI_CONSTRAINTS.sql
    • CD_WAI_INDEXES.sql
  5. If you want to create the State Store database tables in this database, run the following scripts as the newly created user (schema owner):
    • DP_STATE_TABLES.sql
    • DP_STATE_CONSTRAINTS.sql
    • DP_STATE_INDEXES.sql
  6. If you want to create the State Store database tables in this database, in the folder Database\Scripts\Oracle\Shared\85\, run the following script as the newly created user (schema owner):
    • DP_STATE_SET_VERSION.sql
  7. In the folder Database\Scripts\Oracle\Shared\85\, run the following script as the newly created user (schema owner):
    • GENERAL_SET_VERSION.sql
  8. In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Web administrator (defaults to TRIDION_SYS):
    • CD_FINALIZE_RIGHTS.sql
    The script removes rights that the new user no longer needs.
  9. In the folder Database\Scripts\Oracle\Shared\85\, run the following script as the SQL SDL Web administrator (defaults to TRIDION_SYS):
    • TCM_FINALIZE.sql

Results

You have manually created the Content Data Store, and optionally the State Store, as an Oracle database.

What to do next

When installing a Server Role, you configure the Content Data Store in the Storage Layer configuration file.