Oracle Initial load extract abends when ORA-01555 error is encountered, ORA-01555 caused by SQL statement below...

(Doc ID 1577262.1)

Last updated on JANUARY 18, 2017

Applies to:

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


Initial Load from Oracle 9i on HP-UX to Oracle 11g on Linux 
The extract ends successfully but the databases were not synchronized.
After some diagnostics, we could saw on the source Oracle database alert log, the following error:

Mon Jul 23 19:34:32 2012
ORA-01555 caused by SQL statement below (Query Duration=10094 sec, SCN: 0x087e.ad5461a6):
Mon Jul 23 19:34:32 2012


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