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_rep_init.sql
script on the replicate database to add the relevant Replication Server system
tables to the replicate database. You can find the script in the
$SYBASE/scripts directory on UNIX or
%SYBASE%\scripts directory on Windows.
The script also inserts relevant values and grants the required permissions in the replicate database.