Unsupported Datatypes

Owned by Chris Lawless (Unlicensed)

Last updated: May 28, 2014

1 min read

The 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)

*TIMESTAMP with TIMEZONE expressed as offsets are supported.

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