Replication Agent supports the replication of data stored in XMLTYPE columns from an Oracle primary database to an Oracle or Adaptive Server Enterprise replicate database. Replication Agent also supports the replication of data stored in XMLTYPE tables from an Oracle primary database to an Oracle replicate database. Replication Agent only supports the replication of XMLTYPE columns and tables stored as CLOB data.
Replication Agent ignores the XML encoding statement in XMLTYPE data because CLOB data is always encoded in the Oracle database character set.
Even for a partial updates, Oracle logs the entire contents of the CLOB column in which XMLTYPE data is stored. Replication Agent also replicates the entire contents of the CLOB column.
