Oracle GoldenGate – Extract Types

HTML Table

Oracle GoldenGate – Extract Types
About Me Muhammad Rawish Siddiqui
Some of My Articles
Autonomous & Cloud Database Specialist
Oracle Database Fleet Administrator
High Availability and Disaster Recovery Consultant
Oracle Certified Expert
Professional Oracle ERP DBA
EC-Concil Disaster Recovery Professional

Integrated Extract
– Is an Oracle GoldenGate Extract for Oracle Databases
– Is Multi-Threaded
– Relies on Oracle’s internal log parsing and processing implementation
– Supports more data types
– Supports Downstream Topologies
– Is available with OGG version 11.2.1 and later

Classic Extract
– Is a traditional REDO log-based Extract for Oracle
– Works on all supported DB platforms and versions
– Does not work in an Oracle Multitenant environment
– Does not support three-part naming convention for objects (e.g PDB.SCHEMA.TABLE)


Share This

Muhammad Rawish Siddiqui

Master in Computer Science (Database Engineering) and PGD in Management Information System.
45+ Online Certifications, which includes EDRP (EC-Council Disaster Recovery Professional), Data Management, Security+, DBaaS - Cloud Certified Expert, Oracle Cloud Autonomous Database Specialist, Oracle Database Cloud Certified Professional, Oracle Cloud Infrastructure, OCP 7.3, 10g, 11g, 11i, R12, OCE/OCS 11i System Administration, Solaris, Linux and Real Application Cluster 10g, 11g, Oracle Autonomous Database, Real Application Cluster, Oracle Data Guard and Performance Tuning etc. .

Foremost interested areas include, Data Management, Oracle Databases and EBS Health Checks, Real Application Cluster, Disaster Recovery, GoldenGate and Oracle Cloud.
Notify of
Inline Feedbacks
View all comments