DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR...ORA-04045: errors during recompilation/revalidation of SYS.DBMS_GOLDENGATE_ADM
(Doc ID 2660327.1)
Last updated on MAY 26, 2020
Applies to:Oracle GoldenGate - Version 18.104.22.168.4 and later
Information in this document applies to any platform.
While trying to setup AUTO_CDR for first time user was encountering below error:
schema_name => '<SCHEMA>',
table_name => '<TABLE>',
record_conflicts => TRUE);
/ 2 3 4 5 6 7
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_GOLDENGATE_ADM
ORA-04088: error during execution of trigger 'SYS.GGS_DDL_TRIGGER_BEFORE'
ORA-00604: error occurred at recursive SQL level 2
ORA-04045: errors during recompilation/revalidation of GGMON.DDLREPLICATION
ORA-04067: not executed, package body "GGMON.DDLREPLICATION" does not exist
ORA-06508: PL/SQL: could not find program unit being called:
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