Creating a Database Replication Subscription

Create a database replication subscription.

1. Make a copy of the rs_create_test_db_sub.sql script named my_rs_create_db_sub.sql.

   cp rs_create_test_db_sub.sql
   my_rs_create_db_sub.sql

2. Before executing the my_rs_create_db_sub.sql script, change all occurrences of {pds}.{pdb} and {rds}.{rdb} to the appropriate connection name, where:

   • pds is the name of the primary Oracle server.

   • pdb is the primary Oracle System ID (SID).

   • rds is the replicate Oracle System ID (SID).

   • rdb is any valid identifier. Sybase recommends that you use the replicate Oracle SID (SID).

   Note:

   Save the values of pds and pdb to be used later for the rs_source_ds and rs_source_db parameters in the Replication Agent oracle.rs file.

   Here is an example of create database replication subscription:

   create subscription NY_sub1

   for database replication definition NY_repdef1

   with primary at NY.NYora92

   with replicate at DCOServer.oratest2

   without materialization

   go

3. Connect to Replication Server and execute:

   isql -Usa -P –SSAMPLE_RS -i my_rs_create_db_sub.sql

   You see a message indicating that the subscription is being created.