Example 3: Replicating an XMLTYPE table from Oracle to Oracle

A table, defined by the following DDL, must be replicated:

CREATE TABLE sampletable OF XMLTYPE;

This statement creates a simple XMLTYPE table with one implicit CLOB column that can be accessed through a default pseudocolumn named XMLDATA.

The user manually creates a replication definition on Replication Server using the following RCL and the hidden column SYS_NC_OID$, which contains the object ID for sampletable:

create replication definition ra$xxx_sampletable

with primary at myprimary.pdb

with all tables named sampletable (

SYS_NC_OID$ rs_oracle_binary,

XMLDATA text )

primary key (SYS_NC_OID$)

go

The Replication Server name for the Oracle RAW datatype is rs_oracle_binary.

The user then marks the table for replication:

pdb_setreptable sampletable, mark

The user creates a corresponding table at the replicate Oracle database:

CREATE TABLE sampletable OF XMLTYPE;