My Oracle Support Banner

In Bi-Directional Replication, Supplemental Logging via DDL Is NOT Replicated to the Target Unless the Extract on the Target Is Running. (Doc ID 1472420.1)

Last updated on DECEMBER 02, 2019

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


After supplemental logging is enabled by been adding for a table(either by ADD TRANDATA command or Automatically by the EXTRACT ADDTRANDATA param), captured DDL changes should be sent to the target environment. In the problem case, INFO TRANDATA command on the target shows showing Supplement logging Disabled. 

If you start EXTRACT on the target you will see supplemental logging enabled, but sometimes extract on the target extract may be down and you want to ensure that all operations are captured correctly on the new target table.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.