客户系统经常报错误ORA-02067,搜了一下,有关这个错误的解释几乎都是:
Cause: A failure (typically a trigger or stored procedure with multiple remote updates) occurred such that the all-or-nothing execution of a previous Oracle call cannot be guaranteed.
Action: rollback to a previous savepoint or rollback the transaction and resubmit.
下面是我的一个模拟过程:
C:>sqlplus system/system@orcl
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 9月 3 21:33:32 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create table t(id int primary key) tablespace users;
表已创建。
SQL>
--=============