oracle drop表级联约束语句挂
我正在发布一个简单的删除表级联约束表，但它永远挂起。等待几个小时后，如果我按下 SQL Developer 中的取消按钮，它会显示“用户取消了操作”，就像我是罪魁祸首一样。在我开枪自杀之前，请给我建议。
挂了很久之后弹出如下对话框：
Error encountered: An error was encountered performing the requested operation:
ORA-00600: internal error code, arguments: [15264],[],[],[],[],[],[],[]
*Cause: This is the generic internal error number for Oracle program exceptions.
This indicates that a process has encountered an exceptional conndition
I'm issuing a simple drop table cascade constraints table , but it is hanging forever. After waiting for hours, if I press the cancel button in the SQL Developer, it says "User cancelled operation" like I'm the culprit. Please advice, before I shoot myself.
After hanging for a long time it pops up a dialog box as follows:
Error encountered: An error was encountered performing the requested operation:
ORA-00600: internal error code, arguments: [15264],[],[],[],[],[],[],[]
*Cause: This is the generic internal error number for Oracle program exceptions.
This indicates that a process has encountered an exceptional conndition
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
首先，如果某个操作似乎挂起，明智的做法是查找其正在执行的操作的指示 - 例如，在
V$SESSION_WAIT或V$SESSION_LONGOPS中代码>.如果存在引用该表的重要外键约束，那么使用级联约束选项删除需要一些时间也就不足为奇了，因为这将必须删除或更新其他表中的行。
不管怎样，现在您已经遇到了 ORA-600 错误，数据库服务器上应该有一个包含更多信息的跟踪文件。您可能对此感兴趣，但很可能您需要咨询 Oracle 支持人员。
In the first place, if an operation seems to be hanging, a wise thing to do is look for an indication of what it's doing -- e.g. in
V$SESSION_WAITorV$SESSION_LONGOPS.If there were significant foreign key constraints referencing this table, it's not necessarily surprising that it would take time to drop with the cascade constraints option, since that would have to either delete or update rows in other tables.
Anyway, now that you've gotten to an ORA-600 error, there ought to be a trace file on the database server with more information. It may be of interest to you, but most likely you will need to consult Oracle support.