首页 > 数据库技术 > 详细

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

时间:2018-12-22 21:14:18      阅读:221      评论:0      收藏:0      [点我收藏+]

转自: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

原文:https://www.cnblogs.com/sharpest/p/10162315.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!