To enable 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 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.
If the pdb_setrepcol command returns information that the LOB column has replication disabled, continue this procedure to enable 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 enable replication for the LOB column:
pdb_setrepcol pdb_table, pdb_col, enable
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 enable replication.
After replication is enabled for the LOB column (and if replication is enabled for the table that contains the column), any transaction that affects the data in that column will be replicated.
You can use the pdb_setrepcol command again to verify that replication is now 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 for which you want to verify that replication is enabled.
