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 11.1.1.1.3 and later
Information in this document applies to any platform.

Symptoms

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
SELECT x."DATA_BASE",x."CODITPROD",x."FILIAL",x."TPDEPOS",x."PRODUTO",x."DISPONIVEL",x."FISICO",x."RESFIS",x."LOGICO",x."RESLOG",x."TRANSITO",x."FUTURO",x."TECNICO",x."VENDA_FIS_ULT_07",x."VENDA_FIS_ULT_30",x."SETOR",x."LINHA",x."CUSTO_TECNICO",x."PRECO_VENDA",x."CLASSE",x."ZZ_COMO",x."ZZ_QUANDO",x."ZZ_QUEM",x."ESTOQUEPA",x."TRANSITOFAT",x."ESTOQUEVIR",x."ESTOQEFETIVO",x."DATA_PRIMEIRA_ENTRADA",x."DATA_ULTIMA_VENDA_LOJA",x."DATA_ULTIMA_VENDA_CD" FROM "ADM"."MAG_T_PRODUTO_FILIAL_DIARIO" x


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