Information on how on compare/repair works on LOB tables.
The parameter SP_DEQ_SKIP_LOB directs the behavior of the compare config and compare table commands, with respect to tables containing LOB columns.
When the parameter is set to the default of 0, the compare processes compare and repair tables with LOBs.
When the parameter is set to 1, tables with LOBs are processed, but only non-LOB columns are compared and repaired. The LOB columns are ignored.
Set this parameter on the source system:
Default: 0
Range of valid values: 0 or 1 (flag)
Takes effect: immediately available for the next comparison
There are other ways to exclude LOBs (and BLOBs and CLOBs and the like) from compare:
Use the “exclude” option in compare and specify the LOB columns in the list. Here is the syntax:
compare OWNER.SOURCE_TABLE_NAME { exclude} "(column_list")
Deploy the command “compare using <filename>” and use a config file that only lists our table to be compared in it. The file should use the vertical partitioning and exclude the LOB column(s) in it that are not to be compared.
The above workaround also apply to Repair.
