Unable to drop GoldenGate user: ORA-20782: Cannot DROP object used in Oracle GoldenGate replication while trigger is enabled
Last updated on SEPTEMBER 10, 2014
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Unable to drop the GoldenGate user. The following error is returned:
SQL> drop user GGS cascade;
drop user GGS cascade
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-20782: Oracle GoldenGate DDL Replication Error: Code :ORA-20782: Cannot
DROP object used in Oracle GoldenGate replication while trigger is enabled.
Consult Oracle GoldenGate documentation and/or call Oracle GoldenGate Technical
Support if you wish to do so., error stack: ORA-06512: at line 231
ORA-06512: at line 957
The GoldenGate installation has been deleted/removed some time ago, and you are not sure what version of GoldenGate was used.
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