Unmarking a table

To unmark a table for replication use the pdb_setreptable command. It returns replication marking status; unmarks all user tables or a specified table for replication; and disables replication for all marked tables or a specified table. The following is an example of the pdb_setreptable command that forces unmarking for all marked tables in the primary database:

pdb_setreptable all, unmark, force

Use the following procedure to unmark tables for replication with Mirror Replication Agent.

1. Log in to the Mirror Replication Agent instance with the administrator login.

2. Use the pdb_setreptable command to confirm that the table is marked in the primary database:

   pdb_setreptable pdb_table
   

   Here, 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.

3. Use the pdb_setreptable command to disable replication from the table:

   pdb_setreptable pdb_table, disable
   

   Here, pdb_table is the name of the table in the primary database that you want to disable.

4. Use the pdb_setreptable command to remove the replication marking from the table:

   pdb_setreptable pdb_table, unmark
   

   Here, 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
   

5. Use the pdb_setreptable command to confirm that the table is no longer marked for replication:

   pdb_setreptable pdb_table
   

   Here, pdb_table is the name of the table in the primary database that you unmarked.