Support for replicating certain datatypes into Oracle datatypes

ECDA 15.0 ESD #3 supports replicating these Sybase datatypes:

• bigint

• unsigned bigint

• unsigned integer

• unsigned smallint

• unsigned tinyint

• unichar

• univarchar

• unitext

ECDA 15.0 ESD #3 supports replicating the Oracle nclob datatype.

None of the replication components (Replication Agent, Replication Server, or ECDA) supports replicating these Oracle datatypes:

• UROWID

• REF

• MLSLABEL

• VARRAY

• Nested Tables

• Associative arrays

• Oracle-supplied datatypes

  • “Any” Types (SYS.ANYTYPE, SYS.ANYDATA, SYS.ANYDATASET)

  • XML Types (XMLType, URIType, DBURIType, XDBURIType, HTTPURIType)

  • 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

• User-defined datatypes (UDDs) that contain a LOB column.

• UDDs that are not final