My Oracle Support Banner

Integrated Extract Facing LAG Due To Snapshot Query Error 1466 (Doc ID 2465449.1)

Last updated on AUGUST 23, 2021

Applies to:

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


Integrated Extract facing huge lag.

When enabling xml GoldenGate activity logging for the extract, we can see this message:

2018-10-09 19:00:30.770 INFO |ggstd.ptrace                  |main| 8730 ggdbora/dboci8.c         | Encounter snapshot-related error 1466 on snapshot fetch by key query.


The 1466 is Oracle RDBMS error for Snapshot Query feature:

$ oerr ora 1466
01466, 00000, "unable to read data - table definition has changed"
// *Cause: Query parsed after tbl (or index) change, and executed
//         w/old snapshot
// *Action: commit (or rollback) transaction, and re-execute



 Goldengate extract using FETCHOPTIONS USESNAPSHOT, which uses RDBMS Snapshot Query underneath.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.