Skip to Content
0
Former Member
Oct 27, 2009 at 04:22 PM

utlu102i.sql - exact fetch returns more than requested no of rows error

68 Views

I am doing an oracle upgrade from 9.2.0.2 to oracle 10g in hpux11.31 here.

As a pre steps we need to run the enclosed script. While running the script as sysdba, I am getting the below error message.

Can u help me to figure this out?

*

kdecc03:orats3 68> sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Oct 27 10:26:04 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

SQL> pwd

SP2-0042: unknown command "pwd" - rest of line ignored.

SQL> spool preupgrade.sql

SQL> @/install/819830/SAP/utlu102i.sql

DECLARE

*

ERROR at line 1:

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

ORA-06512: at line 2597

*

Regards

Senthil