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 11.2.0.0.
Therefore, compressed tables can only be captured from Oracle DB 11.2 and source database parameter COMPATIBLE must be set to 11.2.0.0 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.
Related/Further Reading:
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
Next Task For You
Want to move ahead in your career and want to get a higher Earning Job?
Get 7+ Courses for DBAs & Apps DBA in a bundle program and learn from the Industry’s best Experts
Leave a Reply