The unsupported 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.