ORA-30926: unable to get a stable set of rows in the source tables
今天在做etl載入歷史資料,處理到8月份的時候,報錯 ORA-30926: unable to get a stable set of rows in the source tables,該etl過程中有用merge語句,google該錯誤的解釋:
Oracle Error :: ORA-30926
Cause
A stable set of rows could not be got because of large dml activity or a non-deterministic where clause.
Action
Remove any non-deterministic where clauses and reissue the dml.
non-deterministic 非確定性的到底指的是什麼呢?再搜
ORA-30926: unable to get a stable set of rows in the source tables" error if there is either a many-to-one or many-to-many relationship between the source and target tables. This is not as serious as it sounds because you would normally have to MERGE a one-to-one or one-to-zero relationship as your join condition would be protected by the target's primary key.
When performing a merge statement, the table to be merged had multiplerecords with the same key used for matching. While this is ok forrecords to be inserted into the target table, Oracle doesn't like thison the update portion of the statement. The solution is to remove the
duplicate or pick a matching key that is truely unique.
此處說明了,merge在做update子句的時候,違反target的主鍵約束可能會導致ora-30926 錯誤。
找出procedure,檢視source,和target,結果看到source的確有重複記錄,而且在清洗的時候沒能發現這個bug。
好了,可以手工把重複記錄刪除,至少不影響歷史資料的載入了。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10159839/viewspace-364685/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- lombok get/set 與 JavaBean get/setLombokJavaBean
- python:get和setPython
- 淺說 get set
- C# Get SetC#
- 快速生成get、set方法
- 初學 PHP __set ( ) 和 __ get ( )PHP
- git SSL certificate problem: unable to get local issuer certificateGit
- JavaScript get set 訪問器屬性JavaScript
- 私有屬性的Get Set 與 Public
- set,env,export,source,exec傻傻分不清楚?Export
- python的__get__、__set__、__delete__(1)Pythondelete
- [GuzzleHttp\Exception\RequestException] cURL error 60: SSL certificate problem: unable to get localHTTPExceptionError
- GIT clone報錯: SSL certificate problem: unable to get local issuer certificateGit
- 【Case】ORA-20000: Unable to set values for table DBMS_TABCOMP_TEMP_UNCMP
- Failed ALPN negotiation: Unable to find compatible protocol&&subscriptionExpressions have not been set yetAIGoProtocolExpress
- Redis中PipeLine使用(二)---批量get與批量setRedis
- Lombok生成get/set異常問題(Lombok缺陷)Lombok
- java反射呼叫set和get方法的通用類Java反射
- 【rac故障】root.sh報錯Unable to get VIP info for new node
- 11.2.0.4 RAC CSSD服務無法啟動故障 unable to set priority to 4CSS
- Vue之computed(計算屬性)詳解get()、set()Vue
- [20190522]How to get dump or list parameters set at session level.txtSession
- IDEA不使用lombok,如何快速生成get和set方法IdeaLombok
- 封裝中的get、set方法-學習筆記封裝筆記
- Unable to execute SonarScanner analysis: Fail to get bootstrap index from server: Host is unreachable(Host unreachable)AIbootIndexServer
- windows 環境下使用 Node.js 遇到 unable to get local issuer certificateWindowsNode.js
- Color Rows and Columns
- Oracle TablesOracle
- 原型鏈上的get與set訪問器屬性原型
- JavaScript rows 屬性JavaScript
- 搞定 Redis 資料儲存原理,別隻會 set、get 了Redis
- file_get_content s()獲取https出現這個錯誤Unable to find the wrapperHTTPAPP
- [重慶思莊每日技術分享]-PSU實施異常unable to get oracle owner forOracle
- 【JavaSE】淺談TreadLocal,TreadLocal的常用方法set()、get()、remove()原始碼分析JavaREM原始碼
- Bean類自動生成判斷null值的Set()和Get()方法BeanNull
- C#中類的屬性訪問器--get和set分析C#
- mysql關於FLUSH TABLES和FLUSH TABLES WITH READ LOCK的理解MySql
- FIRST_ROWS_n(轉)
- F. Color Rows and Columns