当前位置:Gxlcms > 数据库问题 > ORA-04098 trigger 'DBBJ.DB_EV_ALTER_ST_METADATA' is invalid and failed re-validation

ORA-04098 trigger 'DBBJ.DB_EV_ALTER_ST_METADATA' is invalid and failed re-validation

时间:2021-07-01 10:21:17 帮助过:10人阅读

转自:https://blog.csdn.net/dragoo1/article/details/9411105

ORA-04098: trigger ‘DBBJ.DB_EV_ALTER_ST_METADATA‘ is invalid and failed re-validation

主要是禁用触发器
C:\Users\Administrator>sqlplus "/ as sysdba"

SQL> alter trigger DBBJ.DB_EV_ALTER_ST_METADATA disable;

Trigger altered.

SQL> commit;

Commit complete.

SQL> alter trigger DBBJ.DB_EV_DROP_ST_METADATA disable;

Trigger altered.

SQL> COMMIT;

Commit complete.

http://hi.baidu.com/study_discuss/item/d7a4a1136bb9846f70d5e851
http://hi.baidu.com/suncb09/item/6313e3ccc15f9a4da9ba941b
http://www.itpub.net/thread-1794793-1-1.html

---------------------
作者:dragoo1
来源:CSDN
原文:https://blog.csdn.net/dragoo1/article/details/9411105
版权声明:本文为博主原创文章,转载请附上博文链接!

ORA-04098 trigger 'DBBJ.DB_EV_ALTER_ST_METADATA' is invalid and failed re-validation

标签:tail   let   commit   ora   https   原创   来源   and   drag   

人气教程排行