My Oracle Support Banner

DDL Replication Error: Alter trigger Rename Fails With ERROR OGG-00519 Fatal error executing DDL - ORA 00933 (Doc ID 2165611.1)

Last updated on JANUARY 05, 2017

Applies to:

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


On source ALTER TRIGGER  RENAME was executed but replicat failed:

EXTRACT (integrated)
2016-05-20 14:45:35 INFO OGG-01487 DDL found, operation [ALTER TRIGGER ID_CHECK RENAME TO ID_CHECK_NEW (size 46)], start SCN [990663], commit SCN [990673] instance [ (1)], DDL se
qno [0], marker seqno [0].

REPLICAT (integrated)
2016-05-20 14:45:36 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [933], ORA-00933: SQL command not properly ended SQL ALTER TRIGGER ID_CHECK RENAME TO
"AROYTARGET"."ID_CHECK_NEW" /* GOLDENGATE_DDL_REPLICATION */], no error handler present.


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.