GoldenGate不支援壓縮表問題OGG-01028 Table compression is not supported
Goldengate的俘獲程式報錯:
Ggserr.log日誌錯誤資訊:
2011-05-11 15:26:55 INFO OGG-01487 Oracle GoldenGate Capture for Oracle, extsb.prm: DDL found, operation [ create table "TEST".DBMS_TABCOMP_TEMP_UNCMP tablespace "PUB_NORM_SPACE" nologging as select /*+ FULL("TEST"."COMM_DEVICE_ACCOUNT") */ * from "TEST"."COMM_DEVICE_ACCOUNT" sample block( 99) mytab (size 213)], start SCN [3998597773213], commit SCN [3998597773473] instance [BGP (1)], DDL seqno [2473], marker seqno [2473].
2011-05-11 15:26:55 INFO OGG-00488 Oracle GoldenGate Capture for Oracle, extsb.prm: DDL operation excluded [EXCLUDE INSTR 'DBMS_TABCOMP_TEMP_UNCMP',], optype [CREATE], objtype [TABLE], objowner [TEST], objname [DBMS_TABCOMP_TEMP_UNCMP].
2011-05-11 15:26:55 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, extsb.prm: Object with object number 97076 is compressed. Table compression is not supported.
2011-05-11 15:26:55 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extsb.prm: PROCESS ABENDING.
檢視資料庫中沒有壓縮表:
select owner,table_name,compression,compress_for from dba_tables where compression='ENABLED';
同事在俘獲程式extsb中增加了下面的內容,用來排除這兩個臨時表則解決了上面的問題
TABLEEXCLUDE TEST.DBMS_TABCOMP_TEMP_CMP
TABLEEXCLUDE TEST.DBMS_COMPRESSION
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12778571/viewspace-695158/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 表壓縮(Table Compression)技術介紹Oracle
- GoldenGate無法同步壓縮表問題Go
- Oracle Index Key Compression索引壓縮OracleIndex索引
- Nginx R31 doc-11-Compression and Decompression 壓縮與解壓縮Nginx
- Oracle Hybrid Columnar Compression(HCC) 混合列壓縮Oracle
- GoldenGate - What is supported and what is not ....Go
- 並查集系列之「路徑壓縮( path compression ) 」並查集路徑壓縮
- Oracle表壓縮Oracle
- oracle 表壓縮Oracle
- C# 關於壓縮、加密、解壓問題C#加密
- Kafka - 支援壓縮種類Kafka
- Oracle壓縮黑科技(一)—基礎表壓縮Oracle
- webpack4 css打包壓縮問題WebCSS
- oracle壓縮表(一)Oracle
- oracle壓縮表(二)Oracle
- oracle 的表壓縮Oracle
- Oracle表的壓縮Oracle
- 表壓縮技術
- Flutter asset檔案被壓縮的問題Flutter
- Oracle10g備份集壓縮新特性(Backupset Compression)Oracle
- 壓縮table and index 對 space 的影響testIndex
- MySQL 5.6的表壓縮MySql
- MYSQL壓縮表測試MySql
- Sqlserver表和索引壓縮SQLServer索引
- 【表壓縮】使用表壓縮技術將表所佔用空間降低到最小
- myisampack工具(MyISAM表壓縮工具)
- 【問題】 table 和column 查詢表定義
- extjs js壓縮問題及佈署一體JS
- vue-element-admin 解決壓縮打包之後背景圖片不顯示問題Vue
- Nginx網路壓縮 CSS壓縮 圖片壓縮 JSON壓縮NginxCSSJSON
- 資料夾不壓縮怎麼加密設定密碼 不壓縮加密最簡單辦法加密密碼
- JAVA壓縮和解壓縮Java
- zip壓縮和解壓縮
- 【EXPDP】11g版本EXPDP 的COMPRESSION引數壓縮比堪比“gzip -9”
- openGauss 支援OLTP場景資料壓縮
- linux壓縮解壓縮Linux
- 字串的壓縮和解壓縮字串
- 檔案壓縮和解壓縮