goldengate 的initial load 當目的表無pk或者ui時會產生重複記錄
OGG can insert duplicate rows when there is no unique index primary key UI PK defined [ID 1350948.1]
Information in this document applies to any platform.
Applies to:
Oracle GoldenGate - Version: 9.5_EA and later [Release: 9.5.0 and later ]Information in this document applies to any platform.
Symptoms
Target table with no UI or PK has duplicate rows after initial load.Replicat is (may be) using HANDLECOLLISIONS and KEYCOLS
Changes
An initial load.Cause
It is possible to get duplicate rows because there is no key / index constraint to prevent it. Keycols will not help.Solution
Replicat relies on the database to return a constraint error when a duplicate row is inserted. In cases where there is no UI or PK, no error is returned. HC will not help because there is no error. KEYCOLS is used as a retrieval mechanism, not an index on a write.The fact that replicat treats the whole row as a key when there is no defined key is no help.
Replicat has no way of knowing it should not insert a duplicate row if there is no constraint.
User must define a key or UI.[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1055385/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE GoldenGate Initial LoadOracleGo
- GoldenGate表的重新再同步(無需生產端時間視窗)Go
- goldengate 目的端同步無主鍵無索引表時的rpt日誌(做update操作)Go索引
- mysql表刪除重複記錄方法MySql
- Oracle如何刪除表中重複記錄Oracle
- 查詢刪除表中重複記錄
- MySQL時區導致無法產生表MySql
- Oracle 刪除表中重複記錄的DELETE SQLOracledeleteSQL
- 高效快速刪除Oracle表中重複記錄Oracle
- Oracle刪重複記錄Oracle
- 處理表重複記錄(查詢和刪除)
- MySQL 當記錄不存在時插入,當記錄存在時更新MySql
- MySQL刪除表重複記錄的三種方法舉例MySql
- 刪除Oracle重複記錄Oracle
- SQL重複記錄查詢SQL
- oracle刪除重複記錄Oracle
- 解決生產日誌重複列印的問題
- index_stats 記錄產生Index
- 資料庫存資料時,邏輯上防重了為啥還會出現重複記錄?資料庫
- Oracle如何刪除表中重複記錄保留第一條Oracle
- 用dbms_error記錄load時的錯誤Error
- db2刪除重複的記錄DB2
- oracle-快速刪除重複的記錄Oracle
- 用SQL語句去掉重複的記錄SQL
- 關於SQL的重複記錄問題SQL
- Oracle查詢重複資料與刪除重複記錄Oracle
- Laravel/Lumen 記錄MySQL 和 MongoDB 產生的 SQL,定位 SQL 產生位置LaravelMySqlMongoDB
- 當初自學C++時的筆記記錄C++筆記
- 利用sql語句找出表中有重複記錄的三種sql寫法SQL
- 利用Oracle GoldenGate記錄源系統所有表的操作OracleGo
- Oracle查詢重複資料與刪除重複記錄方法Oracle
- 高併發下如何避免產生重複資料?
- DB2 刪除重複記錄DB2
- MySql避免重複插入記錄的幾種方法MySql
- MYSQL中刪除重複記錄的方法薦MySql
- goldengate基於表複製Go
- 關於goldengate 對源表和目的表的表結構一致的定義Go
- OGG的initial load和online change sync