Creating an Oracle publish undo database manually

Create your Oracle publish undo database manually by running database scripts that create the database and its tables.

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 created the publish undo database.