oracle – 如何解决:SQL错误:ORA-00604:在递归SQL级别1发生错误

前端之家收集整理的这篇文章主要介绍了oracle – 如何解决:SQL错误:ORA-00604:在递归SQL级别1发生错误前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
当我试图丢桌时,我得到了错误

sql Error: ORA-00604: error occurred at recursive sql level 2
ORA-01422: exact fetch returns more than requested number of rows
00604. 00000 -  "error occurred at recursive sql level %s"
*Cause:    An error occurred while processing a recursive sql statement
           (a statement applying to internal dictionary tables).
*Action:   If the situation described in the next error on the stack
           can be corrected,do so; otherwise contact Oracle Support.

解决方法

一种可能的解释是为每个DROP TABLE语句触发的数据库触发器.要查找触发器,请查询_TRIGGERS字典视图:

select * from all_triggers
where trigger_type in ('AFTER EVENT','BEFORE EVENT')

禁用任何可疑触发器

alter trigger <trigger_name> disable;

并尝试重新运行DROP TABLE语句

猜你在找的Oracle相关文章