My Oracle Support Banner

OGG Integrated Extract Captures Incorrect Table Name for ALTER TRIGGER DDL (Doc ID 2355140.1)

Last updated on FEBRUARY 12, 2018

Applies to:

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

Symptoms

2017-05-24 14:17:33 INFO OGG-01487 DDL found, operation [ALTER TRIGGER "FAST"."LISTINGCOLLECTIONTRIG" COMPILE DEBUG (size 59)], start SCN [11681953651856], commit SCN [11681953651862] instance [ (1)], DDL seqno [0], marker seqno [0].

2017-05-24 14:17:33 INFO OGG-00487 DDL operation included [INCLUDE MAPPED], optype [ALTER], objtype [TRIGGER], objowner [FAST], objname [KBB_DATA]. <==== objname is wrong.

Extract is capturing ALTER TRIGGER object name incorrectly

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!


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