Configuring Tables for CONFIG Schema

Tables need to be configured in the Relational Replication database CONFIG schema for multi-server purging.

Procedure

1. In the release pack, retrieve the SQL scripts from location RelationalReplicationXXX.zip/database_schema/oracle/4_RR_CONFIG_TABLE_SCRIPTS.sql.

2. Run the scripts in the Relational Replication database CONFIG schema. Check that the tables listed below have been created.

   • RR_APP_PURGE
   • RR_PURGE_RUNNING_STATUS
   • TMN_DF_JOB_EXTRACT_ARC
   • RR_LOCK_JOB_SELECT_PURGE