Rebuild Index Online Causes Extract/Replicat Abend
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.
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
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 , object id .
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.
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