Example: Replicating XMLTYPE Column Data from Oracle to Oracle

Replicate XMLTYPE column data from an Oracle primary database to an Oracle replicate database.

CREATE TABLE sampletable
( col1 INT,
  col2 INT,
  xml1 XMLTYPE,
  xml2 XMLTYPE);

1. Manually create a replication definition on Replication Server this RCL command:

   create replication definition ra$xxx_sampletable
   with primary at myprimary.pdb
   with all tables named sampletable (
   col1 int,
   col2 int,
   xml1 as SYS_NC00004$ text,
   xml2 as SYS_NC00006$ text )
   primary key (col1, col2)
   go

   Note: If the Replication Agent pdb_auto_create_repdefs configuration parameter is set to true, a replication definition is created automatically.
2. Mark the table for replication:

   pdb_setreptable sampletable, mark

3. Because of the hidden CLOB columns, you must enable replication for the table using pdb_setrepcol:

   pdb_setrepcol sampletable, enable

4. Create a corresponding table at the replicate Oracle database:

   CREATE TABLE sampletable
   ( col1 INT,
     col2 INT,
     xml1 XMLTYPE,
     xml2 XMLTYPE);

   Note: If DDL replication has been enabled, manually create the replicate table.