Documentation Center

Creating an Oracle Discovery Service database manually

Create your Oracle Discovery Service database manually by running database scripts that create the database and its tables.

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. In the folder Database\Scripts\Oracle\Shared\85\, 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 Web 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\85\, run the following script as the SQL SDL Web administrator (defaults to TRIDION_SYS):
    • TCM_FINALIZE.sql