Enabling Replication for a LOB Column in a Marked Table

Enable replication for a 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 pdb_table is the marked table that contains the LOB column.

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

   If pdb_setrepcol returns information that the LOB column has replication disabled, continue this procedure to enable 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. Enable replication for the LOB column:
   

   pdb_setrepcol pdb_table, pdb_col, enable

   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 is replicated.

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

   pdb_setrepcol pdb_table, pdb_col