Disabling replication for LOB columns

StepsTo disable replication for a LOB column in a marked table

  1. Log in to the Replication Agent instance with the administrator login.

  2. Use the pdb_setrepcol command to verify that replication is enabled for the LOB column:

    pdb_setrepcol pdb_table, pdb_col
    

    where:

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

    NoteThe table that contains the LOB column must be marked for replication before replication can be enabled or disabled for a LOB column.

  3. Use the pdb_setrepcol command to disable replication for the LOB column:

    pdb_setrepcol pdb_table, pdb_col, disable
    

    where:

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

  4. 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: