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 Oracle nclob datatype. However, as of ECDA 15.0 ESD #2, this datatype is supported. For further information, see Appendix A, “Datatype Translation and Mapping” in the Replication Server 15.2 Heterogeneous Replication Guide.

None of the replication components (Mirror 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