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

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

  • 2013/09/29
  • GoldenGate
  • 1,460 views
  • OGG-01028 Oracle GoldenGate Capture for Oracle,Table compression is not supported已关闭评论

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

Related Posts:

打赏

对不起，这篇文章暂时关闭评论。

上一篇：

下一篇：