After you apply the dump from the primary database or dump source to the replicate database, reinitialize the replicate database to restore users, tables, and permissions that the dump removed.
- If maintenance and DDL users do not exist in the primary database, add them to the replicate database after you apply the dump from the primary database.
- Run the hds_oracle_new_setup_for_replicate.sql script on the replicate
database to add the relevant Replication Server system tables to the replicate
database.
The script also inserts relevant values and grants the required permissions in the replicate database.