1、进入GoldenGate安装目录，运行ggsci.exe
2、关闭运行中的进程
info all
stop *
stop mgr
3、退出ggsci.exe，从ogg目录进入 sqlplus
sqlplus "/as sysdba"
4、运行ddl_disable.sql脚本来禁用DDL触发器
SQL> @ddl_disable.sql
触发器已更改
5、运行ddl_remove.sql脚本来移除GoldenGate DDL触发器、DDL历史和标记表以及其他相关的对象。
注意：Enter Oracle GoldenGate schema name：处输入DDL信息所在用户
SQL> @ddl_remove.sql
DDL replication removal script.
WARNING: this script removes all DDL replication objects and data.
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
Enter Oracle GoldenGate schema name:ggs
Working, please wait ...
Spooling to file ddl_remove_spool.txt
Script complete.
6、运行marker_remove.sql脚本来移除GoldenGate marker支持系统。
SQL> @marker_remove.sql
Marker removal script.
WARNING: this script removes all marker objects and data.
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
Enter Oracle GoldenGate schema name:ggs
PL/SQL 过程已成功完成。
序列已删除。
表已删除。
Script complete.
7、如果用户是专门用来存放DDL信息的，可以删除用户
SQL> drop user ggs cascade;
用户已删除