Replicating datatypes for Oracle

This section lists the datatypes supported and unsupported by ExpressConnect for Oracle for replicating into and out of Oracle.

Table 1 lists the Sybase® datatypes supported and not supported by ExpressConnect for Oracle for replicating into Oracle.

**Table 1: 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)

Table 2 lists the Oracle datatypes that are supported and not supported by ExpressConnect for Oracle for replicating into Oracle.

**Table 2: 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 LOB updates
	char	ref
	clob	UDDs containing LOB
	date	UDDs that are not final
	interval day to second	urowid
	interval year to month	varray
	long	SecureFile LOBs
	long raw
	nchar
	nclob
	number
	nvarchar2
	raw
	rowid
	simple_integer
	timestamp
	timestamp with [local] time zone
	UDD object type (only for replication not gateway)
	varchar2
	xmltype (limited support, handled as clob)

Table 3 lists the Oracle datatypes that are supported and not supported by Replication Agent for replicating out of Oracle.

**Table 3: Supported and unsupported Oracle datatypes**
Datatype	Supported	Unsupported
Oracle	anydata (limited support)	associative array
	bfile	mlslabel
	binary_double	nested tables
	binary_float	Oracle-supplied datatypes
	blob	partial LOB updates
	char	ref
	clob	UDDs containing LOB
	date	UDDs that are not final
	interval day to second	SecureFile LOBs
	interval year to month	urowid
	long	varray
	long raw
	nchar
	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.
All Oracle 11g XML Types (XMLType, URIType, DBURIType, XDBURIType, HTTPURIType) as well as Oracle 10g XML Types stored as XML Types (not as CLOB).
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.

XMLType stored as CLOB can be replicated to Oracle and to Adaptive Server® Enterprise. When replicating to Oracle, use ExpressConnect for Oracle since it is not supported by ECDA Option for Oracle.
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.
While Replication Agent supports marking procedures that use SIMPLE_INTEGER PL/SQL type, it does not support marking procedures that use PLS_INTEGER PL/SQL type or any of its other subtypes.