This post covers How to replicate compressed table in the database, one of the common query that we get frequently from our trainees in our training Oracle GoldenGate 12c Administration.
We have noticed as per our experience during training, there are some of the common queries/issues faced by trainees while they are supporting the Goldengate environment or setting up the new environment. Hence we have come up with a blog series on those common issues/questions and resolution. Here is the second Query:
Check here for the first query How to Handle Tables Without Primary Keys/Unique Indexes
How to replicate compressed table in the database?
Q: I have a compressed table in database. How can I replicate it?
Ans: Compressed tables are supported via Integrated Extract from OGG v 11.2.x.
In order for integrated capture to capture compressed tables, the source database COMPATIBLE setting must be at least 220.127.116.11.
Therefore, compressed tables can only be captured from Oracle DB 11.2 and source database parameter COMPATIBLE must be set to 18.104.22.168 or higher.
Note: OGG does not support compressed tables or partitions, neither does it handle it well with proper error messages until OGG v10.4.x.
This post is from our Oracle GoldenGate 12c Administration Training, in which we cover Architecture, Installation, Configuring & Preparing the Environment, DML Replication – Online Change Synchronization, Initial Load, Zero Downtime Migration & Upgrading using GoldenGate, Oracle GoldenGate Security, Performance of Oracle GoldenGate and Troubleshooting and much more.
If you are just starting out in Goldengate then I highly recommend you to go through these posts first
- Oracle GoldenGate 12c Overview & Components
- Oracle GoldenGate 12c Download & Installation
- FAQ’s: Oracle GoldenGate 12c
- FAQ’s: Oracle GoldenGate 12c: Part II
- Oracle GoldenGate 12c Training : Step by Step Activity Guides /Hands-On Lab Exercise
- Oracle GoldenGate 12c Administration
Did You Register For FREE GoldenGate Webinar?
NO! So your next task is to get yourself register for our FREE Webinar on Learn Oracle GoldenGate 12c for Replication & Migration to start your Goldengate journey. Click on the image below to register for FREE.
Do you have any queries in Oracle GoldenGate 12c? please reach out to us at firstname.lastname@example.org