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 12.2.0.1.0 and later
Information in this document applies to any platform.

Goal

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.

Solution

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