No or limited support for replicating certain datatypes into Oracle datatypes

ECDA 15.0 ESD #1 or earlier does not support replicating these Sybase datatypes. However, as of ECDA 15.0 ESD #2, these datatypes are supported:

• bigint

• unsigned bigint

• unsigned integer

• unsigned smallint

• unsigned tinyint

• unichar

• univarchar

• unitext

ECDA 15.0 ESD #1 or earlier does not support replicating the nclob Oracle datatype. However, as of ECDA 15.0 ESD #2, this datatype is supported.

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

  • User-defined datatypes (UDDs) that are not final

Workaround: None.