Oracle upgrade problem u0800060.sql

Gino Castoldi_2 — Thu, 12 Jun 2003 14:15:35 GMT

Hi,

HP-UX 11.0 Oracle 8.0.6 VPO 6.14.

We are in the process of upgrading Oracle database from release 8.0.6 to 8.1.7.

We're at the point where we need to run the upgrade script
"u0800060.sql". I cd'ed to the
$ORACLE_HOME_rdbms/admin - directory as user oracle -
($ORACLE_HOME=$ORACLE_BASE/product/8.1.7).

I logged into SVRMGRL and did a "connect internal".
The problem is when I run the script "u0800060.sql" it does not run.
SVRMGR> u0800060.sql
2>
3> ;
u0800060.sql
*
ORA-00900: invalid SQL statement
SVRMGR> quit

Any ideas as to what is wrong?

10 points to any good answer.
Thank you
Gino

Re: Oracle upgrade problem u0800060.sql

A. Clay Stephenson — Thu, 12 Jun 2003 14:19:42 GMT

Unless this is a typo, you left off the '@'.
u0800060.sql
should be @u08000060.sql

Re: Oracle upgrade problem u0800060.sql

Gino Castoldi_2 — Thu, 12 Jun 2003 14:26:42 GMT

Hi Clay,

That did the trick!

Thank you again.

topic Re: Oracle upgrade problem u0800060.sql in Operating System - HP-UX

Oracle upgrade problem u0800060.sql

Re: Oracle upgrade problem u0800060.sql

Re: Oracle upgrade problem u0800060.sql