Unable to drop GoldenGate user: ORA-20782: Cannot DROP object used in Oracle GoldenGate replication while trigger is enabled
(Doc ID 1924642.1)
Last updated on FEBRUARY 11, 2024
Applies to:
Oracle GoldenGate - Version 11.1.1.0.0 and laterInformation in this document applies to any platform.
Goal
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.
Solution
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
Goal |
Solution |