GoldenGate Replicat Abend With OGG-00516 ORA-04080 Trigger 'XXX' Does Not Exist. (Doc ID 1386913.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle GoldenGate - Version: 10.0.0.0 and later   [Release: 10.0.0 and later ]
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate (OGG) replicat abenda with the following error:

ERROR OGG-00516 Oracle GoldenGate Delivery for Oracle, myreplicat.prm: Fatal error executing DDL replication: error [Error code [4080], ORA-04080: trigger 'MY_TRIGGER' does not exist, SQL ALTER TRIGGER "MY_SCHEMA"."MY_TRIGGER" COMPILE REUSE SETTINGS /* GOLDENGATE_DDL_REPLICATION */], due to explicit ABEND error handling and filter [include all (default)].ORA-04080 trigger 'XXX' does not exist.

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