How to drop golden gate user from oracle database?

you cant drop the golden gate user when DDL replication set up in ON.

system wont allow you to drop the user  and you will get the below error.

Error ORA-20782 while deleting Golden Gate User

we can drop the user in TWO ways.

1.disable & Drop the trigger associated with it then drop the user.

2.SQL> @ddl_disable.sql

SQL> @ddl_remove.sql

SQL> @marker_remove.sql

-- Now try deleting the user and remove the installed directory.

SQL> drop user ggadmin cascade;