Oracle GoldenGate – Extract Types



HTML Table

Oracle GoldenGate – Extract Types
About Me Muhammad Rawish Siddiqui
rawishsiddiqui@yahoo.ca
https://www.linkedin.com/in/rawishsiddiqui
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







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.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments