Replicating Datatypes Out of Oracle

Oracle datatypes that are supported or not supported by Replication Agent for replicating out of Oracle using XStream APIs.

Supported and Unsupported Oracle Datatypes
Supported	Unsupported
`binary_double`	`bfile`
`binary_float`	`rowid`
`blob`	`ref`(user-defined datatype)
`clob`	`varray`(user-defined object)
`char`	`nested tables` (user-defined object)
`date`	`xmltype` (such as `binary xml`)
`interval day to second`
`interval year to month`
`number`
`raw`
`timestamp`
`timestamp with [local] time zone`
`timestamp with time zone`

Oracle-Supplied Datatype Limitations

Replication Agent cannot replicate some Oracle-supplied datatypes, because XStream APIs do not support them in row Logical Change Records (LCRs).

“ANY” types (SYS.ANYTYPE, SYS.ANYDATASET)
BFile
ROWID
User-defined datatypes, such as REF, including these object types:
- NESTED TABLE
- VARRAY
XMLType object stored relationally or as a binary XML
Media types (ORDSYS.ORDAudio, ORDSYS.ORDImage, ORDSYS.ORDImageSignature, ORDSYS.ORDVideo, ORDSYS.ORDDoc, SI_StillImage, SI_Color, SI_AverageColor, SI_ColorHistogram, SI_PositionalColor, SI_Texture, SI_FeatureList)
Spatial types (MDSYS.SDO_GEOMETRY, SDO_TOPO_GEOMETRY, SDO_GEORASTER)
Uniform Resource Identifier (URI) Types

These datatype restrictions are applicable to both ordinary (heap-organized) tables and index-organized tables. For descriptions about these tables, see the Oracle documentation.

Replication Agent for Oracle Limitations

The limitations for using Replication Agent for Oracle with XStream APIs.

Because Replication Agent for Oracle does not support multiple XStream outbound servers, Multi-Path Replication™ (MPR) is not supported.
Because XStream APIs return only committed transactions, Replication Agent for Oracle does not support replication of stored procedures in which autonomous transactions exist.
Because the data definition language (DDL) LCR does not return the global temporary table details from an XStream outbound server, replication of temporary tables is not supported.
Because XStream APIs does not support changes to a table created with the reference partition, Replication Agent for Oracle cannot replicate Data Manipulation Language (DML) statements on such tables.