在11g数据库上安装goldengate，运行@ddl_setup.sql时有如下错误
ERROR at line 1:
ORA-20782: Creating GGS_DDL_RULES table:ORA-01031: insufficient privileges:ORA-01031: insufficient privileges
ORA-06512: at "GOLDENGATE.INITIAL_SETUP", line 477
ORA-06512: at line 1
错误提示还是很明显的，是权限不足造成的。有人会疑问，都给”grant dba to goldengate“，怎么还会权限不足呢。
这里需要注意：在11gR2数据库中，dba角色中并不包含如下权限：
grant create any table to goldengate;
grant create any view to goldengate;
grant create any procedure to goldengate;
grant create any sequence to goldengate;
grant create any index to goldengate;
grant create any trigger to goldengate;
grant create any view to goldengate;
solution：
额外授上面权限即可。
