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

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


I am doing an oracle upgrade from 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 - Production on Tue Oct 27 10:26:04 2009

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

Connected to:

Oracle9i Enterprise Edition Release - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release - Production

SQL> pwd

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

SQL> spool preupgrade.sql

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



ERROR at line 1:

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

ORA-06512: at line 2597