Supported datatypes in Oracle GoldenGate
Oracle GoldenGate has some restrictions in terms of what it can replicate. With every new release, Oracle is adding new datatypes to the list of what is supported. The list of the datatypes of the objects that you are planning to replicate should be checked against the list of supported datatypes for the GoldenGate version that you are planning to install.
Getting ready
You should have identified the various datatypes of the objects that you plan to replicate.
How to do it…
The following is a high-level list of the datatypes that are supported by Oracle GoldenGate v11.2.1.0.1:
NUMBER
BINARY FLOAT
BINARY DOUBLE
CHAR
VARCHAR2
LONG
NCHAR
NVARCHAR2
RAW
LONG RAW
DATE
TIMESTAMP
CLOB
NCLOB
BLOB
SECUREFILE
andBASICFILE
XML
datatypesUser defined
/Abstract
datatypesSDO_GEOMETRY
,SDO_TOPO_GEOMETRY, and
SDO_GEORASTER
are supported
How it works…
There are some additional details that one needs to consider while evaluating the supported datatypes for a GoldenGate version. For example, the user-defined datatypes are only supported if the source and target tables have the same structures. Both Classic and Integrated Capture modes support XML types which are stored as XML
, CLOB
, and XML binary
. However, XML type tables stored as Object Relational are only supported in Integrated Capture mode.
There's more…
The support restrictions apply to a few other factors apart from the datatypes. Some of these are as Manipulating Data:
INSERTs
,UPDATEs
andDELETEs
are supported on regular tables, IOTs, clustered tables and materialized viewsTables created as
EXTERNAL
are not supportedExtraction from compressed tables is supported only in Integrated Capture mode
Materialized views created with
ROWID
are not supportedOracle GoldenGate supports replication of the sequences only in uni-directional mode