OS：redhat as 4
DB：Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
为一个表增加分区，于是split partition，开始都很顺利，当执行到如下sql时报错：
SQL> alter table ereport.log_login_lost
2 split partition p20080822 at (to_date('2008-08-22 00:00:00','yyyy-mm-dd hh24:mi:ss'))
3 into (partition p20080821 ,partition p20080822 );
/
alter table ereport.log_login_lost
split partition p20080822 at (to_date('2008-08-22 00:00:00','yyyy-mm-dd hh24:mi:ss'))
into (partition p20080821 ,partition p20080822 )
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_INDCOMPART_BOPART$) violated
确认是：Bug No. 5650955
Bug No. 5650955
Filed 08-NOV-2006 Updated 17-NOV-2006
Problem statement:
ORA-00001: UNIQUE CONSTRAINT (SYS.I_INDPART_BOPART$) VIOLATED--------------------------------------------------------------------------------
*** 11/08/06 11:46 am *** TAR: ---- .
PROBLEM:--------------------------------------------------------------------------------
Subsequent partition spliting operations causes .
ORA-00001: unique constraint (SYS.I_INDPART_BOPART$) violated .
DIAGNOSTIC ANALYSIS:
--------------------------------------------------------------------------------
Reproduce the error on local environments.
Requested backport request of Bug 3748430 but the patch is not fixing the issue. .
WORKAROUND:--------------------------------------------------------------------------------
Rebuild entire partitioned table; not acceptable. .
RELATED BUGS:--------------------------------------------------------------------------------
3748430 .
REPRODUCIBILITY:--------------------------------------------------------------------------------
Solaris/Windows . TEST CASE:
--------------------------------------------------------------------------------
. .
STACK TRACE:--------------------------------------------------------------------------------
not available. .
SUPPORTING INFORMATION:--------------------------------------------------------------------------------
. 24 HOUR CONTACT INFORMATION FOR P1 BUGS:--------------------------------------------------------------------------------
.
DIAL-IN INFORMATION:--------------------------------------------------------------------------------
.
IMPACT DATE:--------------------------------------------------------------------------------
.
*** 11/08/06 11:48 am *** *** 11/08/06 05:00 pm *** (CHG: Asg->NEW OWNER)
*** 11/08/06 10:20 pm *** (CHG: Sta->10)
*** 11/08/06 10:20 pm ***
*** 11/09/06 06:44 am *** (CHG: Sta->92)
*** 11/09/06 06:44 am *** *** 11/17/06 07:36 am
*** Public support update:
the issue was fixed by patch 3748430 only after mandatory patch 5117016 had been installed,
therefore this was closed as 'not a bug' . .
看来用不升级到10.2.0.4.0有很多风险啊。
参考：http://forums.oracle.com/forums/thread.jspa?threadID=430452
另外thomas zhang对该情况由一个比较详细的分析：
http://space.itpub.net/785478/viewspace-571007
