Verify config failed with the following messages:
20: XCREWIFS.CHAIN_DAILY_HIST XCREWIFS.CHAIN_DAILY_HIST VMH-AC-NLDB-P01-dbs:QXCREWIFS_LOB@o.PNLAC Specification will be skipped --> Column CHD_DETAILS type CLOB - cannot replicate XMLTYPE column which is not stored as a CLOB
21: "XCREW"."CHAIN_DAILY_HIST" "XCREW"."CHAIN_DAILY_HIST" VMH-AC-NLDB-P01-dbs:QXCREW_LOB@o.PNLAC
However, table ddl script shows table has column with xmltype and its data is stored in CLOB.
Oracle internal table opqtype$ returns a value different than four (4) for that table's opqtype$.flag. Oracle Bug 16234917
Explanation:
To replicate table with xmltype column, xmltype column's data MUST be stored in CLOB. Shareplex would query Oracle internal table sys.opqtype$ to validate and ensure that xmltype column's data is stored in CLOB.
opqtype$.flag has the following value:
flags number, /* flags for the opaque type */
/* -------------- XMLType flags ---------
* 0x0001 (1) -- XMLType stored as object
* 0x0002 (2) -- XMLType schema is specified
* 0x0004 (4) -- XMLType stored as lob
* 0x0008 (8) -- XMLType stores extra column
*
* 0x0020 (32)-- XMLType table is out-of-line
* 0x0040 (64)-- XMLType stored as binary
* 0x0080 (128)- XMLType binary ANYSCHEMA
* 0x0100 (256)- XMLType binary NO non-schema
*/
Shareplex queries opqtype$ table for flag value, and if the result returns a value different than four(4), then activation skips that table with message: cannot replicate XMLTYPE column which is not stored as a CLOB.
Contact Support
