Topic: 删除竟然删了3个小时…… |
Print this page |
1.删除竟然删了3个小时…… | Copy to clipboard |
Posted by: gaoxt1983 Posted on: 2006-11-07 13:09 4个表,删其中一个表(表A),那个表2xx条数据,然后他有一个表外键关联与这个表(表,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-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1 客服电话 18559299278 客服信箱 714923@qq.com 客服QQ 714923 |