Improved Support for Table Replication for Oracle GoldenGate
In earlier releases, extracting tables to Oracle GoldenGate required supplemental logging data to replicate table/schema, and required you to set TABLE/TABLEEXCLUDE
parameters to configure which table to extract.
Starting with this release, to coordinate with the Oracle GoldenGate feature OGG EXTRACT
, the LOGICAL_REPLICATION
clause now provides support for automatic extract of tables.
In addition, two new views, DBA_OGG_AUTO_CAPTURED_TABLES
and USER_OGG_AUTO_CAPTURED_TABLES
, provide you with tools to query which tables are enabled for Oracle GoldenGate automatic capture.