Creating an Integrated Capture with a downstream database for compressed tables

Logical replication between two databases is a complex task. The level of complexity is quite dependent on the data types of the underlying data that you are replicating. When you add additional features offered by an Oracle database, for example compression, the complexity increases further. Until quite recently, Oracle GoldenGate did not support replicating data from a source database where the data was stored in compressed tables. With the launch of Oracle GoldenGate 11gR2, Oracle has added a new capture mode called Integrated Capture using which you can extract data from compressed tables. The Integrated Capture uses a logminer dictionary which you can either place ...

Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.