有张远程表,进行同一条记录多次操作后就会出以下错误,这张表没有索引,没有主健,记录共有200W条左右。请大伙分析一下为什么。
SQL>INSERT INTO PD_DELL_ORDER_RECEIVE_DTL @me_to_up(order_no,tie_no,tie_code,tie_desc,tie_qty,line_no,mod_no,mod_desc,mod_qty,vendor_name,vendor_phone,vendor_fax,service_intruction,item_cost,snp_part_flag,pick_flag,forwarder) VALUES ('467133961','2','9403CA922','M9403CA922 - Dell 922 Photo Color All-In-One Printer','1','3','WDPH15-SA','Standard Telephone Technical Support Service, 800-858-2311','1','NA','N','NA','','0.0','D','N','DELL')
已创建一行
SQL>INSERT INTO PD_DELL_ORDER_RECEIVE_DTL @me_to_up(order_no,tie_no,tie_code,tie_desc,tie_qty,line_no,mod_no,mod_desc,mod_qty,vendor_name,vendor_phone,vendor_fax,service_intruction,item_cost,snp_part_flag,pick_flag,forwarder) VALUES ('467133961','2','9403CA922','M9403CA922 - Dell 922 Photo Color All-In-One Printer','1','3','WDPH15-SA','Standard Telephone Technical Support Service, 800-858-2311','1','NA','N','NA','','0.0','D','N','DELL')
已创建一行
SQL>INSERT INTO PD_DELL_ORDER_RECEIVE_DTL @me_to_up(order_no,tie_no,tie_code,tie_desc,tie_qty,line_no,mod_no,mod_desc,mod_qty,vendor_name,vendor_phone,vendor_fax,service_intruction,item_cost,snp_part_flag,pick_flag,forwarder) VALUES ('467133961','2','9403CA922','M9403CA922 - Dell 922 Photo Color All-In-One Printer','1','3','WDPH15-SA','Standard Telephone Technical Support Service, 800-858-2311','1','NA','N','NA','','0.0','D','N','DELL')
ERROR 位于第1 行:
ORA-02055: 分布式更新操作失效;要求回退
ORA-02068: 以下严重错误源于ME_TO_TODB23
ORA-03113: 通信通道的文件结束
SQL> rollback;
回退已完成
SQL>INSERT INTO PD_DELL_ORDER_RECEIVE_DTL @me_to_up(order_no,tie_no,tie_code,tie_desc,tie_qty,line_no,mod_no,mod_desc,mod_qty,vendor_name,vendor_phone,vendor_fax,service_intruction,item_cost,snp_part_flag,pick_flag,forwarder) VALUES ('467133961','2','9403CA922','M9403CA922 - Dell 922 Photo Color All-In-One Printer','1','3','WDPH15-SA','Standard Telephone Technical Support Service, 800-858-2311','1','NA','N','NA','','0.0','D','N','DELL')
已创建一行
上面提到ORA-03113: 通信通道的文件结束,但其实并没有断线,rollback后,再操作又可以成功insert.