Very often in these forums I get asked the question regarding data types which GoldenGate supports or Oracle software versions or questions like can it work with a database running in NOARCHIVELOG mode or does it support Partitioned and Index Organised tables and so forth.
I have included some snippets taken from the official documentation as well as some of my own experiences and hopefully it will help answer many of the those frequently asked questions.
What Oracle Versions are supported?
Oracle 9.2 and above, Oracle 10.1 and 10.2 and Oracle 11gR1 and 11gR2
How many Extract or Replicat processes can we start?
GoldenGate supports upto 300 Extract and Replicat processes per GoldenGate instance. But keep in mind that each process consumes around 50 MB of memory.
What Oracle Data Types are supported?
NUMBER
BINARY FLOAT
BINARY DOUBLE
CHAR
VARCHAR2
LONG
NCHAR
NVARCHAR2
RAW
LONG RAW
DATE
TIMESTAMP
CLOB
NCLOB
BLOB (SECUREFILE and BASICFILE are both supported.)
XML data types
User defined types
Oracle GoldenGate supports user defined types (UDT) when the source
Continue reading GoldenGate – What is supported and what is not ….
Popular Posts