Documentation Center

Creating an Oracle Content Data Store database manually

Create your Oracle Content Data Store database manually by running the database scripts provided.

Procedure

  1. Access your SDL Tridion installation media.
  2. In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Tridion 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\71\ 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. In the folder Database\Scripts\Oracle\Shared\71\, run the following script as the newly created user (schema owner):
    • GENERAL_SET_VERSION.sql
  6. In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Tridion administrator (defaults to TRIDION_SYS):
    • CD_FINALIZE_RIGHTS.sql
    The script removes rights that the new user no longer needs.
  7. In the folder Database\Scripts\Oracle\Shared\71\, run the following script as the SQL SDL Tridion administrator (defaults to TRIDION_SYS):
    • TCM_FINALIZE.sql

Results

You have manually created the Content Data 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.