Example: Replicating XMLTYPE Column Data from Oracle to Adaptive Server Enterprise

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

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

1. Manually create a replication definition on Replication Server using 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 Adaptive Server Enterprise database using the hidden column names from the primary database table:

   create table sampletable
   ( col1 int,
   col2 int,
   SYS_NC00004$ text,
   SYS_NC00006$ text)
   go

   Note: The XMLTYPE columns from the Oracle primary database table map to text columns in the Adaptive Server Enterprise replicate database table.