Use the same procedure to unmark tables for replication with either a log-based Replication Agent or a trigger-based Replication Agent. For non-RASD instances, Replication Agent must be in Admin state when unmarking.
To unmark a table in the primary database
Log in to the Replication Agent instance with the administrator login.
Use the pdb_setreptable command to confirm that the table is marked in the primary database:
pdb_setreptable pdb_table
where pdb_table is the name of the table in the primary database that you want to unmark.
If the pdb_setreptable command returns information that the specified table is marked, continue this procedure to unmark the table.
If the pdb_setreptable command does not return information that the specified table is marked, you need not continue this procedure.
Use the pdb_setreptable command to disable replication from the table:
pdb_setreptable pdb_table, disable
where pdb_table is the name of the table in the primary database that you want to disable.
Use the pdb_setreptable command to remove the replication marking from the table:
pdb_setreptable pdb_table, unmark
where pdb_table is the name of the table in the primary database that you want to unmark.
If you need to force the unmark, you can use the following command:
pdb_setreptable pdb_table, unmark, force
Use the pdb_setreptable command to confirm that the table is no longer marked for replication:
pdb_setreptable pdb_table
where pdb_table is the name of the table in the primary database that you unmarked.
You can unmark all marked objects in the primary database
by invoking the pdb_setreptable command
with the all keyword.
