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 and BASICFILE
  • XML datatypes ...

Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.