GoldenGate不支援壓縮表問題OGG-01028 Table compression is not supported

mengzhaoliang發表於2011-05-12

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章