When replicating lobs, following error appears:
Information for conflict 9987010048446 (current conflict): Table: DW_STG.TAG_IMAGES at transaction 0008.00b.00163a98 at SCN 202061879403 SQL text (with replaced bind values): update "DW_STG"."TAG_IMAGES" set "SCANNED_IMAGE" = '' where (1=1) and "SCANNED_IMAGE" = '' and "TAG" = 6934626 and "CT006_ID" = 'TUL' Error: ORA-00932: inconsistent datatypes: expected - got BLOB
LOB column in this case is SCANNED_IMAGE column. The problem in this case is, that Dbvisit Replicate with Limited edition(LTD), does not replicate LOBs and MINE process leaves the column empty. The apply then incorrectly handles this record.
To solve this problem, please upgrade to Extended (XTD) or better edition: http://www.dbvisit.com/products/dbvisit-replicate-editions
But its also recommended to go through the user guide and see if Datatypes are supported or Unsupported for the particular version.