G Support for Classic Extract
This topic describes data types, objects and operations that are supported by Oracle GoldenGate Classic Extract.
Data type | Classic capture |
---|---|
Scalar columns including |
Captured from redo. |
|
Not supported. |
|
LOB modifications done using DML
( LOB modifications done using
|
|
Captured from redo, except for the following cases
where
|
Index Organized Tables (IOT) |
Captured from redo with the following restrictions:
|
XML columns stored as CLOB |
Captured from redo. |
XML columns stored as Binary |
Fetched from source table. |
XML columns stored as Object-Relational |
Not supported. |
XML Type Table |
Not supported. |
User Defined Type (UDT) columns |
Fetched from source table. |
Invisible Columns |
Not supported. |
|
Fetched from source table with the following data types only:
UDTs
Requires source database compatibility to be set to 11.2.0.0.0 or higher. |
Spatial Types columns |
Fetched from source table. |
Collections columns ( |
Fetched from source table. |
Collections columns (Nested Tables) |
Fetched from source table with limitations. See Details of Support for Objects and Operations in Oracle DML. |
Object Table |
Fetched from source table. |
Transparent Data Encryption (Column Encryption & Tablespace Encryption) |
Captured from redo. |
Basic Compression |
Not supported. |
OLTP-Compression |
Not supported. |
Exadata Hybrid Columnar Compression |
Not supported. |
XA on non-RAC database |
Captured from redo. |
XA on RAC database |
Not supported. To get support, must make sure all branches of XA goes to the same instance. |
PDML on non-RAC database |
Captured from redo. |
PDML on RAC database |
Not supported. To get support, you must make sure child transactions spawned from a PDML transaction do not span multiple instances. |
- Details of Support for Objects and Operations in Oracle DML
This section outlines the Oracle objects and operations that Oracle GoldenGatesupports for the capture and replication of DML operations. - Details of Support for Objects and Operations in Oracle DDL (Classic)
This topic outlines the Oracle objects and operation types that Oracle GoldenGate supports for the capture and replication of DDL operations.