ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validat

运行OGG DDL @ddl_setup.sql 时报错，提示以下信息：

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

运行grant GGS_GGSUSER_ROLE to ogg;
提示如下错误：

SQL> grant GGS_GGSUSER_ROLE to ogg2  ;
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 用户权限是要单独赋予的。

先执行下面脚本
SQL> @ddl_disable.sqlTrigger altered.
然后运行后面的脚本正常。
SQL> @ddl_setup.sqlSQL> GRANT CREATE TABLE,CREATE SEQUENCE TO OGG;Grant succeeded.

oracle not a valid month。提示创建ogg 用户时赋予以下权限：

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