Enabling replication for a marked table
Log in to the Replication Agent instance with the administrator login.
Use the pdb_setreptable command to verify that replication is disabled for the table:
pdb_setreptable pdb_table
Here, pdb_table is the name of the marked table you want to enable replication for.
If the pdb_setreptable command returns information that the table is marked and has replication disabled, continue this procedure to enable replication for the table.
A table must be marked for replication before replication
can be enabled or disabled for the table.
Use the pdb_setreptable command to enable replication for the table:
pdb_setreptable pdb_table, enable
Here, pdb_table is the name of the marked table in the primary database for which you want to enable replication.
After replication is enabled for the table, any transaction that affects the data in that table is captured for replication.
You can use the pdb_setreptable command again to verify that replication is now enabled for the table:
pdb_setreptable pdb_table
Here, pdb_table is the name of the marked table for which you want to verify that replication is enabled.
