Details of Support for Data Types, Objects and Operations 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 (`VARRAY`s)	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.