Unsupported Datatypes

Owned by Chris Lawless (Unlicensed)
Last updated: Jun 03, 2016 by Donna Zehl (Unlicensed)
1 min read
Unsupported datatypes are:
  • BINARY_FLOAT
  • BINARY_DOUBLE
  • TIMESTAMP WITH TIMEZONE (TZR) and (TZD)*
  • ROWID
  • UROWID
  • ANYDATA
  • ANYTYPE
  • ANYDATASET
  • XMLTYPE
  • URITYPE
  • SDO_GEOMETRY
  • SDO_GEORASTER
  • SDO_TOPO_GEOMETRY
  • ORD_DICOM
  • Some SECUREFILE LOBs operations (see below)
  • 32K VARCHAR (Oracle 12.1)
  • identity columns (Oracle 12c)

 

*TIMESTAMP with TIMEZONE expressed as offsets are supported.

 If SOURCE tables are created & configured with Oracle Basic Compress option (including at the tablespace level) replication is unsupported for these objects.

A SQL query can be run to determine if there are any datatypes that will not be supported by Dbvisit Replicate.