Unsupported datatypes, data, and structures

The following datatypes are not supported:

• Oracle-supplied datatypes:

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

  • MLSLABEL

  • All Oracle 11g XML Types (XMLType, URIType, DBURIType, XDBURIType, HTTPURIType) as well as Oracle 10g XMLTYPE data stored as XML (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)

  • Datatypes used with Oracle Expression Filter

  • ANYDATA, if it is being replicated to a non-ANYDATA column or if the data exceeds 16KB, which is the size constraint of the Replication Server OPAQUE datatype.

  • BFILE, UROWID, or REF data stored in an ANYDATA column

  • BLOB or Object user-defined datatype data being replicated to a replicate database other than Oracle or ASE. When replicating to Oracle, use ExpressConnect for Oracle since data of these types is not supported by ECDA for Oracle.

  • REF

  • UROWID

• SecureFile LOB

• User-defined datatypes containing LOB data

• User-defined datatypes defined as NOT FINAL

Data stored in the Oracle XML DB Repository is not supported if it is accessed with the following protocols or methods:

• Internet protocols like FTP, HTTP, HTTPS, and WebDAV

• The Oracle XML DB Repository API

The following user-defined object types and structures are not supported:

• Associative arrays

• Nested tables

• VARRAY

• Nested tables or VARRAY stored in an ANYDATA column