Disabling replication for a LOB column in a marked
table
Log in to the Replication Agent instance with the administrator login.
Use the pdb_setrepcol command to verify that replication is enabled for the LOB column:
pdb_setrepcol pdb_table, pdb_col
where:
pdb_table is the name of the marked table that contains the LOB column.
pdb_col is the name of the LOB column you want to disable replication for.
If the pdb_setrepcol command returns information that the LOB column has replication enabled, continue this procedure to disable replication for the column.
The table that contains the LOB column must be marked
for replication before replication can be enabled or disabled for
a LOB column.
Use the pdb_setrepcol command to disable replication for the LOB column:
pdb_setrepcol pdb_table, pdb_col, disable
where:
pdb_table is the name of the marked table that contains the LOB column.
pdb_col is the name of the LOB column for which you want to disable replication.
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.
You can use the pdb_setrepcol command again to verify that replication is now disabled for the LOB column:
pdb_setrepcol pdb_table, pdb_col
where:
pdb_table is the name of the marked table that contains the LOB column.
pdb_col is the name of the LOB column for which you want to verify that replication is disabled.
