My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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

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
Symptoms
Cause
Solution


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