ORA-00001: UNIQUE CONSTRAINT (SYS.WRI$_SQLSET_PLANS_PK) VIOLATED
ora-00001的錯誤很常見,就是違反唯一約束,但發生在系統相關的表中,就可能是bug.當然bug也有不同,有的bug只是oracle程式問題,一般只能打
patch修補或選擇性的忽略,有的bug則其實是人為操作加上oracle程式健壯性共同引起的,解決人為操作的問題,就可以解決.
在11.2.0.4上使用DBMS_SQLTUNE.UNPACK_STGTAB_SQLSET時,報ORA-00001: UNIQUE CONSTRAINT (SYS.WRI$_SQLSET_PLANS_PK)
VIOLATED,實際上可能是執行了多次dbms_sqltune.pack_stgtab_sqlset,導致stage表中存在重複記錄.只需要truncate staging table,然後重新
pack,再unpack就可以了.
參考文件:Bug 21246895 : ORA-00001: UNIQUE CONSTRAINT VIOLATED
patch修補或選擇性的忽略,有的bug則其實是人為操作加上oracle程式健壯性共同引起的,解決人為操作的問題,就可以解決.
在11.2.0.4上使用DBMS_SQLTUNE.UNPACK_STGTAB_SQLSET時,報ORA-00001: UNIQUE CONSTRAINT (SYS.WRI$_SQLSET_PLANS_PK)
VIOLATED,實際上可能是執行了多次dbms_sqltune.pack_stgtab_sqlset,導致stage表中存在重複記錄.只需要truncate staging table,然後重新
pack,再unpack就可以了.
參考文件:Bug 21246895 : ORA-00001: UNIQUE CONSTRAINT VIOLATED
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28539951/viewspace-1811444/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-00001 Unique Constraint SYS.I_JOB_JOB ViolatedAI
- ORA-00001 : Unique Constraint Violated caused by DATE VS Timestamp(6)AI
- ORA-00001: unique constraint (...) violated並不一定是資料衝突AI
- ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated 解決方法AISQL
- Bug 2784796: ORA-00001:UNIQUE CONSTRAINTAI
- :[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint (SCIBMOracleProtocolAI
- Data Warehouse Guide閱讀筆記（六）：unique constraint & unique indexGUIIDE筆記AIIndex
- ORA-02292: integrity constraint (xxxx) violated - child record foundAI
- Bug 9290526 - Poor plan for recursive SQL used for DML involving a UNIQUE constraint [ID 9290526.8]SQLAI
- ConstraintAI
- Unique Array
- MySQL中的 UNIQUE約束和UNIQUE索引MySql索引
- 【YashanDB資料庫】自關聯外來鍵插入資料時報錯：YAS-02033 foreign key constraint violated parent key not found資料庫AI
- 約束CONSTRAINTAI
- constraint約束AI
- Unused&ConstraintAI
- Index Unique Scan (213)Index
- Deferred Constraint CheckAI
- constraint=constraints?AI
- SAP FI-AA Line item causes scrap value of to be violated
- Could not resolve com.android.support.constraint:constraint-layout:1.1.3AndroidAI
- SQL Server Unique ConstratintsSQLServer
- Sparse Indexes vs unique indexIndex
- Leetcode Unique PathsLeetCode
- For the modern unique years event soiree
- oracle Distinct|Unique 異同Oracle
- Unique and Nonunique Indexes (195)Index
- Will attempt to recover by breaking constraintAI
- CONSTRAINT的用法舉例AI
- Constraint deferrable特性研究AI
- constraint deferrable immediate checkAI
- Deferring Constraint ChecksAI
- Leetcode-Unique PathsLeetCode
- Leetcode Unique Paths IILeetCode
- Unique Paths leetcode javaLeetCodeJava
- c++11 :unique_ptrC++
- MySQL——約束(constraint)詳解MySqlAI
- 討論關於Constraint statesAI