转自: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
版权声明:本文为博主原创文章,转载请附上博文链接!

posted on 2018-12-22 20:15  Sharpest  阅读(857)  评论(0编辑  收藏  举报