For transactions that affect a LOB column to be replicated, the table that contains the LOB column must be marked for replication and have replication enabled.
If the value of the pdb_dflt_column_repl parameter is set to true, all LOB columns in a table have replication enabled automatically when you mark the table (by invoking the pdb_setreptable command). If the value of the pdb_dflt_column_repl parameter is set to false, you must enable replication separately for each LOB column before replication can take place.
The default value of the pdb_dflt_column_repl parameter
is false.
To enable replication for a LOB column in the
primary database
Log in to the Replication Agent administration port.
Use the pdb_setrepcol command to determine if replication is already enabled for the LOB column you want to enable replication for in the primary database:
pdb_setrepcol tablename, pdb_col
where:
tablename is the name of the table that contains the LOB column.
pdb_col is the name of the LOB column in the primary database.
If pdb_setrepcol is invoked
with a table containing a “DATE” column, the primary
key in the primary table must not include the “DATE” column.
This is true for all Replication Agents except Replication Agent for Oracle.
If the pdb_setrepcol command returns information that replication is enabled for the specified column, you need not continue this procedure.
If the pdb_setrepcol command returns information that replication is not enabled for the specified column, continue this procedure to enable replication for the column.
Use the pdb_setrepcol command to enable replication for the LOB column:
pdb_setrepcol tablename, pdb_col, enable
where:
tablename is the name of the table that contains the LOB column.
pdb_col is the name of the LOB column in the primary database for which you want to enable replication.
After replication is enabled for the LOB column, you can begin replicating transactions that affect data in that column.
