Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to drop golden gate user

Kenny - SnL!-OracleJun 11 2017 — edited Jun 15 2017

We are no more using golden gate and trying to cleanup golden gate footprint.

As part of it , when i tried to drop the golden gate schema ... it throws the below error.

SQL> drop user GG_USER cascade;

drop user GG_USER 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 310

ORA-06512: at line 1272

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2017
Added on Jun 11 2017
6 comments
900 views