Create your Oracle publish undo database manually by running database scripts that create the database and its tables.
Procedure
- Access your SDL Web installation media.
- 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).
- In the Database\Scripts\Oracle\Shared\71\ folder, run the following script as the newly created user (schema owner):
The script creates a new user (schema owner).
- 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
- In the folder Database\Scripts\Oracle\Shared\71\, run the following script as the newly created user (schema owner):
- In the Database\Scripts\Oracle\Create\ folder, run the following script as the SQL SDL Web administrator (defaults to
TRIDION_SYS):
The script removes rights that the new user no longer needs.
- In the folder Database\Scripts\Oracle\Shared\71\, run the following script as the SQL SDL Web administrator (defaults to
TRIDION_SYS):
Results
You have created the publish undo database.