Unsupported Oracle Datatypes, Data, and Structures

Review the Oracle datatypes that are not supported by Replication Agent.

These datatypes are not supported:

Oracle-supplied datatypes:
- “Any” Types (SYS.ANYTYPE, SYS.ANYDATASET), except for SYS.ANYDATA.
- MLSLABEL
- 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 Adaptive Server® Enterprise (ASE). When replicating to Oracle, use ExpressConnect for Oracle since data of these types is not supported by Enterprise Connect™ Data Access (ECDA) for Oracle.
- REF
- UROWID
User-defined datatypes containing LOB data
User-defined datatypes defined as NOT FINAL
Partial updates to Oracle LOBs are not supported.
Virtual columns – Replication Agent supports the replication of tables containing computed (or virtual) columns in Oracle 11g. However, the replication of individual computed columns is not supported. You can mark tables with virtual columns for replication using the force option, but the virtual columns are not replicated.

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

These user-defined object types and structures are not supported: