Topic: 删除竟然删了3个小时……

  Print this page

1.删除竟然删了3个小时…… Copy to clipboard
Posted by: gaoxt1983
Posted on: 2006-11-07 13:09

4个表,删其中一个表(表A),那个表2xx条数据,然后他有一个表外键关联与这个表(表Black Eye,8xxx条数据,然后表C和表D外键关联与表B,各2xxxx条数据,delete from 表A,怎么会这么慢

2.Re:删除竟然删了3个小时…… [Re: gaoxt1983] Copy to clipboard
Posted by: cxp108
Posted on: 2006-11-07 13:15

delete的时候有人访问数据库?

3.Re:删除竟然删了3个小时…… [Re: gaoxt1983] Copy to clipboard
Posted by: gaoxt1983
Posted on: 2006-11-07 14:07

恩,肯定有人

4.Re:删除竟然删了3个小时…… [Re: gaoxt1983] Copy to clipboard
Posted by: gaoxt1983
Posted on: 2006-11-07 20:04

找到问题了,原来resume时oracle的保留字……

5.Re:删除竟然删了3个小时…… [Re: gaoxt1983] Copy to clipboard
Posted by: cxp108
Posted on: 2006-11-08 08:38

操作失败了?

6.Re:删除竟然删了3个小时…… [Re: gaoxt1983] Copy to clipboard
Posted by: gaoxt1983
Posted on: 2006-11-08 17:18

no , not fail at all , that's why I confuse


   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2018 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号
客服电话 0592-8750026    客服信箱 714923@qq.com    客服QQ 714923