ORA-04098: trigger ‘SYS.GGS_DDL_TRIGGER_BEFORE‘ is invalid and failed re-validation处理

简介: ORA-04098: trigger ‘SYS.GGS_DDL_TRIGGER_BEFORE‘ is invalid and failed re-validation处理

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


4d1d187e70a045e3a778bf532bd47d7c.png

33732b1d0a7f46938aaa45146edcf6d9.png

运行grant GGS_GGSUSER_ROLE to ogg; 报错如下:


c48a662d525240f9931afbb42205a2da.png


2.解决方法


查看官网说是权限问题,但是给ogg 用户赋予dba 权限了,
后来知道即使有dba权限但是ogg 用户权限是要单独赋予的。
SYS@PROD> @ddl_disable.sql
SYS@PROD> GRANT CREATE TABLE,CREATE SEQUENCE TO OGG;
SYS@PROD> @ddl_setup.sql
此时提示成功

6fff697bc4f74d2b9f452f983f3ab82d.png

目录
相关文章
|
Linux
WARNING: Re-reading the partition table failed with error 22: Invalid argument
在划分磁盘分区时,遇到错误“WARNING: Re-reading the partition table failed with error 22: Invalid argument” 如下所示: [root@DB-Server u02]# fdisk -l   Disk /dev/sda: 500.
2551 0
|
SQL 关系型数据库 Oracle
ORA-01466: unable to read data - table definition has changed
1. Oracle建议我们等待大约5分钟之后再进行flashback query新创建的表,否则可能会碰到这个错误ORA-01466: unable to read data - table definition has changed.
1817 0
|
SQL
ORA-02292: integrity constraint (xxxx) violated - child record found
在更新表的主键字段或DELETE数据时,如果遇到ORA-02292: integrity constraint (xxxx) violated - child record found 这个是因为主外键关系,下面借助一个小列子来描述一下这个错误: SQL> create table studen...
2429 0
|
SQL 数据库
SQL logic error or missing database no such table: xxx
原文:SQL logic error or missing database no such table: xxx System.
3576 0