OGG:ALLOWNOOPUPDATES,NOALLOWNOOPUPDATES 引數概念
ALLOWNOOPUPDATES | NOALLOWNOOPUPDATES
Valid for Replicat
複製程式引數
Use ALLOWNOOPUPDATES and NOALLOWNOOPUPDATES to control how Replicat responds to a “noop” operation. A no-op operation is one in which there is no effect on the target table. The
ALLOWNOOPUPDATES 和 NOALLOWNOOPUPDATES 用來處理 “沒有操作的操作” “沒有操作的操作” 例如 源表 set x=a where x=a
following are some examples of how this can occur.
● The source table has a column that does not exist in the target table, or has a column
that was excluded from replication (with a COLSEXCEPT clause). In either case, if that
source column is updated, there will be no target column name to use in the SET clause
within the Replicat SQL statement.
當源表有某些列但是目標表卻沒有,或者複製程式中配置了COLSEXCEPT 引數 在這些情況下,當源表對那些列進行更新,目標表將不發生任何變化
● An update is made that sets a column to the same value as the current one. The
database does not log the new value, because it did not really change. However, Oracle
GoldenGate extracts the operation as a change record because the primary key was
logged — but there is no column value for the SET clause in the Replicat SQL statement.
By default (NOALLOWNOOPUPDATES), Replicat abends with an error because these types of
operations do not update the database. With ALLOWNOOPUPDATES, Replicat ignores the
operation instead of abending. The statistics reported by Replicat will show that an update
was made, but the database will not be updated.
另外更新一個欄位的值更新的值為原來的值,資料庫不會記錄這個新值,因為它沒有發生改變, 然後OGG 抽取程式將這個作為一個操作記錄下來了,這是因為主鍵的存在但是列沒有任何值的變化,根據系統預設的NOALLOWNOOPUPDATES引數設定複製程式將abends 並報錯,因為那些更改沒有在目標庫上做更新。如果使用了ALLOWNOOPUPDATES 引數OGG 將忽略這樣的情況並且不會abend程式統計資訊會記錄update 操作,但是資料庫卻不會發生改變。
Valid for Replicat
複製程式引數
Use ALLOWNOOPUPDATES and NOALLOWNOOPUPDATES to control how Replicat responds to a “noop” operation. A no-op operation is one in which there is no effect on the target table. The
ALLOWNOOPUPDATES 和 NOALLOWNOOPUPDATES 用來處理 “沒有操作的操作” “沒有操作的操作” 例如 源表 set x=a where x=a
following are some examples of how this can occur.
● The source table has a column that does not exist in the target table, or has a column
that was excluded from replication (with a COLSEXCEPT clause). In either case, if that
source column is updated, there will be no target column name to use in the SET clause
within the Replicat SQL statement.
當源表有某些列但是目標表卻沒有,或者複製程式中配置了COLSEXCEPT 引數 在這些情況下,當源表對那些列進行更新,目標表將不發生任何變化
● An update is made that sets a column to the same value as the current one. The
database does not log the new value, because it did not really change. However, Oracle
GoldenGate extracts the operation as a change record because the primary key was
logged — but there is no column value for the SET clause in the Replicat SQL statement.
By default (NOALLOWNOOPUPDATES), Replicat abends with an error because these types of
operations do not update the database. With ALLOWNOOPUPDATES, Replicat ignores the
operation instead of abending. The statistics reported by Replicat will show that an update
was made, but the database will not be updated.
另外更新一個欄位的值更新的值為原來的值,資料庫不會記錄這個新值,因為它沒有發生改變, 然後OGG 抽取程式將這個作為一個操作記錄下來了,這是因為主鍵的存在但是列沒有任何值的變化,根據系統預設的NOALLOWNOOPUPDATES引數設定複製程式將abends 並報錯,因為那些更改沒有在目標庫上做更新。如果使用了ALLOWNOOPUPDATES 引數OGG 將忽略這樣的情況並且不會abend程式統計資訊會記錄update 操作,但是資料庫卻不會發生改變。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26764973/viewspace-1192402/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- goldengate 目的端程式引數APPLYNOOPUPDATES 和ALLOWNOOPUPDATESGoAPPOOP
- ogg引數解析
- OGG引數詳解
- OGG -FILTER 引數過濾Filter
- goldengate OGG引數規範Go
- OGG 行過濾filter 引數Filter
- OGG一些引數說明,帶翻譯!
- OGG-00268 OGG-01668引數檔案格式問題
- OGG classic模式maxtransops引數提升複製效率模式
- ORACLE RAC GUARD配置引數——RAC GUARD概念和管理Oracle
- parallel並行度的相關操作、概念、引數解釋Parallel並行
- OGG-整合模式抽取與資料庫引數streams_pool_size關係模式資料庫
- 由OGG引發的資料庫故障資料庫
- kettle 引數——變數引數和常量引數變數
- LOG_ARCHIVE_DEST_n引數屬性——DATA GUARD概念和管理Hive
- 數學概念
- 由引數檔案配置表對映重複引發的OGG-01154 ORA-00001
- 關於DataPump工具引發OGG中斷原因
- Oracle引數-隱藏引數Oracle
- 【C語言】函式的概念和函式的呼叫(引數傳遞)C語言函式
- 讀懂概率圖模型:從基本概念和引數估計開始模型
- ORACLE OGG引數修改引起佇列檔案異常導致抽取程式無法啟動Oracle佇列
- 什麼是請求引數、表單引數、url引數、header引數、Cookie引數?一文講懂HeaderCookie
- Swift語言中為外部引數設定預設值可變引數常量引數變數引數輸入輸出引數Swift變數
- c# 方法引數_值引數C#
- c# 方法引數_引用引數C#
- 動態引數,靜態引數
- C#中的值引數,引用引數及輸出引數C#
- Swift學習筆記(三十三)——常量引數,變數引數和inout引數Swift筆記變數
- python疑問5:位置引數,預設引數,可變引數,關鍵字引數,命名關鍵字引數區別Python
- JavaScript形式引數和實際引數JavaScript
- Oracle引數檔案解析——引數解析Oracle
- c#方法引數_輸出引數C#
- c# 方法引數_陣列引數C#陣列
- 12.MyBatis學習--對映檔案_引數處理_單個引數&多個引數&命名引數MyBatis
- 引數和變數變數
- Java對比有引數和無引數Java
- nodejs接收get引數和post引數NodeJS