My Oracle Support Banner

Integrated Extract Abends With ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2682327.1)

Last updated on JUNE 26, 2020

Applies to:

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

Symptoms

Integrated Extract abends with following error:

2020-03-28 06:40:47 ERROR OGG-00662 OCI Error ORA-01422: exact fetch returns more than requested number of rows
 (status = 1422).

And following failed SQL/error reported in DB trace file:

----- Current SQL Statement for this session (sql_id=d76yvp1ntv7xb) -----

SELECT BASEOBJV#,COMMIT_SCN,DROP_SCN FROM SYSTEM.LOGMNRC_CON_GG WHERE
LOGMNR_UID = :B3 AND BASEOBJ# = :B2 AND BITAND(SPARE2, :B1 ) = :B1

ORA-01422: exact fetch returns more than requested number of rows

Cause

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
Symptoms
Cause
Solution
References


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