暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

OGG-01028 Oracle GoldenGate Capture for Oracle,Table compression is not supported

原创 Anbob 2013-09-29
1520
Today My product environment using OGG(Version 11.2.1.0.1) the EXTRACT PROCESS ABBENDED. In the following example the output of the ggserr.log
2013-09-29 10:03:15 ERROR OGG-01028 Oracle GoldenGate Capture for Oracle, eicmec.prm: Object with object number 81069 is compressed. Table compression is not supported.
2013-09-29 10:03:15 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, eicmec.prm: PROCESS ABENDING.


sys@ICME>select table_name,owner from dba_tables where COMPRESSION='ENABLED' and OWNER=;
-- none
sys@ICME>select name from obj$ where obj#=81069;
no rows selected
复制

I searched in MOS and find the answer
note 1510691.1
Cause
This issue happens when the extract hits the table DBMS_TABCOMP_TEMP_UNCMP and DBMS_TABCOMBP_TEMP_CMP when the source db is Oracle 11gR2. Since these tables are created and dropped dynamically by Oracle, by the time we check the object ID reported in the error messege, the object ID is already gone.
Solution
The idea is to exclude these tables from replication by doing the below:
tableexclude *.DBMS_TABCOMP_TEMP*
For the extract, to show the object names in question instead of object id, the fix will be from OGG v11.2.1.0.5
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论