Oracle XMLTYPE Datatype Compatibility

Replication Agent supports the replication of XMLTYPE column data stored CLOB or XML from an Oracle 10g, 11g, or 12c primary database to an Oracle 10g, 11g, 12c or SAP Adaptive Server Enterprise replicate database.

However, the XMLTYPE datatype is supported only for replication to Oracle 10g replicate databases. The XMLTYPE stored as CLOB is supported for replication to Oracle 11g or 12c replicate databases. The XMLTYPE stored as text is supproted for replication to SAP Adaptive Server Enterprise replicate databases.

Note: The support for the XMLTYPE stored as CLOB is deprecated in Oracle 12c version. However, Replication Agent for Oracle supports XMLTYPE stored as CLOB for existing columns.