1. Using Oracle GoldenGate for Oracle Database
  2. Support for Classic Extract

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 DATE and DATETIME columns

Captured from redo.

LONG VARCHAR

Not supported.

BASICFILE LOB columns

LOB modifications done using DML (INSERT/UPDATE/DELETE) are captured from redo.

LOB modifications done using DBMS_LOB package are captured from the source table by fetching values from the base table.

SECUREFILE LOB columns

Captured from redo, except for the following cases where SECUREFILE LOBs are fetched from the source table:

  • LOB is encrypted

  • LOB is compressed

  • LOB is deduplicated

  • LOB is stored in-line

  • LOB is modified using DBMS_LOB package

  • NOLOGGING LOBs

Index Organized Tables (IOT)

Captured from redo with the following restrictions:

  • IOT with mapping table not supported.

  • Direct load inserts to IOT tables cannot have the SORTED clause.

  • IOT with prefix compression as specified with COMPRESS clause is not supported.

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.

ANYDATA columns

Fetched from source table with the following data types only:

BINARY_DOUBLE

BINARY_FLOAT

CHAR

DATE

INTERVAL DAY TO SECOND

INTERVAL YEAR TO MONTH

NCHAR

NUMBER

NVARCHAR2

RAW

TIMESTAMP

TIMESTAMP WITH TIME ZONE

TIMESTAMP WITH LOCAL TIMEZONE

UDTs

VARCHAR/VARCHAR2

Requires source database compatibility to be set to 11.2.0.0.0 or higher.

Spatial Types columns

Fetched from source table.

Collections columns (VARRAYs)

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.