O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Handling Oracle Sequences

Although GoldenGate supports the replication of Oracle Sequence values, there are a number of issues we need to be aware of. For example, GoldenGate will support replication using the following methods:

  • Change Data Capture (CDC).
  • Batch processing where checkpoints are not maintained. This is dependent on the SPECIALRUN parameter exiting in the Replicat parameter file.
  • But the following are not supported:
    • Initial loads where the source data is derived from the source tables and not the redo logs, so the sequence values are not extracted.
    • Bi-directional environments. The database sequences must generate values on the target database independent to the source. However, in a cascade environment, GETAPPLOPS must be enabled on ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required