After Interval Partition Drop, Classic Extract Abends: ERROR OGG-01041 ... Failed to prepare fetch on table (Doc ID 2035147.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

Classic extract abends after scheduled interval partition drop:

2015-04-18 09:00:56 INFO OGG-01487 Oracle GoldenGate Capture for Oracle, .......prm: DDL found, operation [ALTER TABLE ...... DROP PARTITION SYS_P14856 UPDATE INDEXES (size 74)], start SCN [734396709], commit SCN [734399022] instance [...... (3)], DDL seqno [4528], marker seqno [4528].
2015-04-18 09:00:56 INFO OGG-00488 Oracle GoldenGate Capture for Oracle, ........prm: DDL operation excluded [EXCLUDE INSTR 'DROP PARTITION'], optype [ALTER], objtype [TABLE], objowner [......], objname [......].
2015-04-18 09:01:02 ERROR OGG-01041 Oracle GoldenGate Capture for Oracle, ........prm: Failed to prepare fetch on table ...... due to lack of defined key columns. Use KEYCOLS.
2015-04-18 09:01:03 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ........prm: PROCESS ABENDING.

 restart works. but abends again in next scheduled job.

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