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

最新推荐文章于 2025-03-28 14:58:28 发布

原创最新推荐文章于 2025-03-28 14:58:28 发布 · 6.2k 阅读

1 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

55 篇文章

订阅专栏

本文介绍了如何在Oracle数据库中禁用导致ORA-04098错误的触发器。通过具体的SQL命令演示了禁用名为'DBBJ.DB_EV_ALTER_ST_METADATA'和'DBBJ.DB_EV_DROP_ST_METADATA'触发器的过程。

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