Unsupported Datatypes

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.

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