Rebuild Index Online Causes Extract/Replicat Abend (Doc ID 1348226.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle GoldenGate - Version 10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting do an index rebuild online, and the extract / replicat uses a wild card select to define the tables,  the extract/replicat will abend on a table with a name like SYS_JOURNAL_%

Command example is:

ALTER INDEX QBO_DATA.ENTRIES_PK REBUILD ONLINE *

Example  messages you will see in the report files

Extract

2010-10-17 12:05:58 GGS WARNING 2203 Problem in resolving [QBO_DATA.SYS_JOURNAL_55049]: Failed to lookup object ID for table QBO_DATA.SYS_JOURNAL_55049, try to fix this issue in order to avoid possible fatal error.

2010-10-17 12:05:58 GGS ERROR 2003 Object was resolved, however in the same resolution call both DDL history and database metadata resolution failed, cannot recover, SCN [983589209], object id [1771569].
------

Replicat

Wildcard MAP resolved (entry QBO_DATA.*):
MAP QBO_DATA.SYS_JOURNAL_52629, TARGET QBO_DATA.SYS_JOURNAL_52629 ;

2010-10-17 10:05:03 GGS ERROR 101 Table QBO_DATA.SYS_JOURNAL_52629 does not exist in target database.
-------

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms