OGG 复制禁用触发器
1.首先,在目标端增加
DBOPTIONS DEFERREFCONST
2.把OGG绑定到ORACLE 上面
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
3. 赋予权限:
exec dbms_goldengate_auth.grant_admin_privilege('ogg','*',TRUE);
exec dbms_goldengate_auth.grant_admin_privilege('system','*',TRUE);