Re: ORA-00942: table or view does not exist error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 15 Nov 2001 06:53:46 +0100
Message-ID: <tv71nlicbef414@corp.supernews.com>

"Sunil Pant" <spant_at_eline.com> wrote in message news:JXFI7.4196$Le.102336_at_sea-read.news.verio.net...
> I recently upgraded to Oracle 8.1.7 Enterprise from 8.15 in solaris 8.
> While creating a stored procedure I received the follwoing error.
> ORA-06553: PLS-707: unsupported construct or
> internal error [2603]
> Someone suggested me to run pupbld.sql in admin folder. After I ran that
I
> couldn't even open TOAD. Now it gives ORA-00942: table or view does not
> exist. But I can log in with SQLPLUS.
>
> Please help. My develpoers use TOAD.
>
> SP
>
>

You did rerun catalog.sql and catproc.sql after the upgrade?

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Wed Nov 14 2001 - 23:53:46 CST