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 the SDL Tridion installation media.
  2. Navigate to the Database\TDM\Scripts\Oracle\Create\ folder.
  3. Run the script CD_BROKER_CREATE_USER.sql as the SQL SDL Tridion administrator (defaults to TRIDION_SYS) to create a new user.
  4. Navigate to the folder Database\TDM\Scripts\Oracle\Create\ and 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
    • CD_FINALIZE_RIGHTS.sql
  5. Navigate to the folder Database\TDM\Scripts\Oracle\Shared\61\ and run the following scripts as the schema owner:
    • TCD_GRANT.sql
    • TCD_REVOKE.sql

Results

You have created the Content Data Store.

What to do next

To configure Content Delivery to use the Content Data Store, see Configuring content storage.