Disabling Replication for a LOB Column in a Marked Table

Disable replication for LOB column.

1. Log in to the Replication Agent instance with the administrator login.
   
2. Determine if replication is enabled for the LOB column:
   

   pdb_setrepcol pdb_table, pdb_col

   where:

   • where pdb_table is the marked table that contains the LOB column.

   • where pdb_col is the LOB column for which you want to disable replication.

   If pdb_setrepcol returns information that the LOB column has replication enabled, continue this procedure to disable replication for the column.

   Note: The table that contains the LOB column must be marked for replication before replication can be enabled or disabled for a LOB column.
3. Disable replication for the LOB column:
   

   pdb_setrepcol pdb_table, pdb_col, disable

   After replication is disabled for the LOB column, transactions that affect the data in that column are not replicated unless replication is enabled for that column again.

4. Verify that replication is now disabled for the LOB column:

   pdb_setrepcol pdb_table, pdb_col