运行OGG DDL @ddl_setup.sql 时报错，提示以下信息：http://www.cndba.cn/cndba/leo1990/article/2835

DDL TRIGGER RUNNING STATUS
----------------------------------------------------------------------
ENABLED
FROM "OGG" ."GGS_SETUP"
            *
ERROR at line 2:
ORA-00942: table or view does not exist

FROM "OGG" ."GGS_SETUP"
            *
ERROR at line 2:
ORA-00942: table or view does not exist

FROM "OGG" ."GGS_SETUP"
            *
ERROR at line 2:
ORA-00942: table or view does not exist

运行grant GGS_GGSUSER_ROLE to ogg;
提示如下错误：http://www.cndba.cn/cndba/leo1990/article/2835

SQL> grant GGS_GGSUSER_ROLE to ogg
  2  ;
grant GGS_GGSUSER_ROLE to ogg
*
ERROR at line 1:
ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation

解决方法：
查看资料说是权限问题，但是给ogg 用户赋予dba 权限了，后来知道即使有dba 权限但是ogg 用户权限是要单独赋予的。http://www.cndba.cn/cndba/leo1990/article/2835http://www.cndba.cn/cndba/leo1990/article/2835

先执行下面脚本
SQL> @ddl_disable.sql

Trigger altered.
然后运行后面的脚本正常。
SQL> @ddl_setup.sql

SQL> GRANT CREATE TABLE,CREATE SEQUENCE TO OGG;

Grant succeeded.

提示创建ogg 用户时赋予以下权限：http://www.cndba.cn/cndba/leo1990/article/2835http://www.cndba.cn/cndba/leo1990/article/2835http://www.cndba.cn/cndba/leo1990/article/2835

grant connect,resource,dba,create table,create sequence to ogg;

版权声明：本文为博主原创文章，未经博主允许不得转载。