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 in the source database itself, or in a separate database called the downstream database. In this recipe we will see how we can create an Integrated Capture extract to read data from compressed tables with a logminer dictionary created in a downstream...