Both Commands Don't Work, "ADD TRANDATA" and "DELETE TRANDATA" (Doc ID 2235636.1)

Last updated on FEBRUARY 24, 2017

Applies to:

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

Symptoms

"DELETE TRANDATA" from GGSCI returns the message "supplemental redo log data is already disabled",
while "ADD TRANDATA" returns the message "supplemental redo log data is already enabled".
"INFO TRANDATA" shows it is disabled.

GGSCI> delete trandata scott.test

Logging of supplemental redo log data is already disabled for table SCOTT.TEST.

GGSCI> add trandata scott.test

Logging of supplemental redo log data is already enabled for table SCOTT.TEST.

GGSCI> info trandata scott.test

Logging of supplemental redo log data is disabled for table SCOTT.TEST.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms