Datatypes for Oracle Replication

Supported and unsupported datatypes for replicating into and out of Oracle.

Replicating Datatypes into Oracle

These Sybase datatypes are supported or unsupported by ExpressConnect for Oracle for replicating into Oracle.

ExpressConnect Supported and Unsupported Sybase Datatypes
Datatype	Supported	Unsupported
Sybase	`bigint`	`bigdatetime`
	`integer`	`bigtime`
	`smallint`
	`tinyint`
	`decimal`
	`numeric`
	`unsigned bigint`
	`unsigned integer`
	`unsigned smallint`
	`unsigned tinyint`
	`unichar`
	`univarchar`
	`unitext`
	`float`
	`double`
	`real`
	`money`
	`smallmoney`
	`date`
	`time`
	`datetime`
	`smalldatetime`
	`timestamp`
	`char`
	`nchar`
	`varchar`
	`nvarchar`
	`text`
	`binary`
	`varbinary`
	`image`
	`bit`
	`sysname` (same as varchar(30))
	`longsysname` (same as varchar(255))
	`user-defined datatypes` (as underlying type)

These Oracle datatypes are supported or unsupported by ExpressConnect for Oracle for replicating into Oracle.

ExpressConnect Supported and Unsupported Oracle Datatypes
Datatype	Supported	Unsupported
Oracle	`anydata` (limited support)	associative array
	`bfile` (only for replication not gateway)	`mlslabel`
	`binary_double`	nested tables
	`binary_float`	Oracle-supplied datatypes
	`blob`	partial large object (LOB) updates
	`char`	`ref`
	`clob`	user-defined datatypes (UDDs) containing LOBs
	`date`	UDDs that are not final
	`interval day to second`	`urowid`
	`interval year to month`	`varray`
	`long`	SecureFile LOBs
	`long raw`	Oracle 11g `xmltype`
	`nchar`
	`nclob`
	`number`
	`nvarchar2`
	`raw`
	`rowid`
	`simple_integer`
	`timestamp`
	`timestamp with [local] time zone`
	`UDD object type`(only for replication not gateway)
	`varchar2`
	Oracle 10g `xmltype` (limited support, handled as `clob`)

These Oracle datatypes are supported or unsupported by Replication Agent for replicating out of Oracle.

Replication Agent Supported and Unsupported Oracle Datatypes
Datatype	Supported	Unsupported
Oracle	`anydata` (limited support)	associative array
	`binary_double`	`bfile`
	`binary_float`	`mlslabel`
	`blob`	nested tables
	`char`	Oracle-supplied datatypes
	`clob`	partial LOB updates
	`date`	`ref`
	`interval day to second`	SecureFile LOBs
	`interval year to month`	UDDs containing LOB
	`long`	UDDs that are not final
	`long raw`	`urowid`
	`nchar`	`varray`
	`nclob`
	`number`
	`nvarchar2`
	`raw`
	`rowid`
	`simple_integer`
	`timestamp`
	`timestamp with [local] time zone`
	`UDD object type`
	`varchar2`
	`xmltype` (limited support, handled as `clob`)

Replication Agent cannot replicate these Oracle-supplied datatypes:

“ANY” types (SYS.ANYTYPE, SYS.ANYDATASET), except for SYS.ANYDATA
Oracle 10g and 11g XMLType data replicated to Oracle 11g. Replication Agent does support replicating XMLType data to Oracle 10g.
Spatial Types (MDSYS.SDO_GEOMETRY, SDO_TOPO_GEOMETRY, SDO_GEORASTER)
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)
Expression filter type
Replication from an ANYDATA column to a non-ANYDATA column
ANYDATA size exceeding 16KB, which is the size constraint of the Replication Server OPAQUE datatype
BFile, UROWID, REF, NESTED TABLE, and VARRAY datatypes stored in the ANYDATA column
XMLType not stored as CLOB

Note: XMLType stored as CLOB can be replicated to Oracle 10g and to Adaptive Server Enterprise. Replication Agent does support replicating XMLType data to Oracle 11g.
Replication of data stored in Oracle XML DB repository using standard protocols such as FTP and HTTP(S) or WebDAV, and other Oracle XML DB API
Marking procedures that use PLS_INTEGER PL/SQL type or any of its other subtypes; however, Replication Agent does support marking procedures that use SIMPLE_INTEGER PL/SQL type.