Unmarking a Table in the Primary Database

Unmark primary database tables.

Prerequisites

For UDB only, Replication Agent must be in Admin state when unmarking.

Task

Log in to the Replication Agent instance with the administrator login.
Determine if the table is marked in the primary database:
```
pdb_setreptable pdb_table
```
where pdb_table is the name of the primary database table that you want to unmark.

If pdb_setreptable returns information that the specified table is marked, continue this procedure to unmark the table.

If pdb_setreptable returns information that the specified table is not marked, you need not continue this procedure.
Disable replication for the table:
```
pdb_setreptable pdb_table, disable
```

Unmark the table:

pdb_setreptable pdb_table, unmark

To force the unmark, use:

pdb_setreptable pdb_table, unmark, force

Confirm that the table is no longer marked for replication:
```
pdb_setreptable pdb_table
```

Note: You can unmark all marked objects in the primary database by invoking the pdb_setreptable command with the all keyword, unless the primary database is UDB.