Re: please help me .. upgrading to 8.1.6 has made my life miserable

Where did you find u0801050.sql my Oracle_Home/Rdbms/Admin dir only has u0801030 and u0801040 ....

Fred Pierce <fpierce_at_avialantic.com> wrote:

>Check to see if sys.standard is invalid and if so try recompiling it. It
>that doesn't work, the next step is to run
>$ORACLE_HOME/rdbms/admin u0801050.sql
>
>I and many others ran into the problem but it's a fairly simple fix.
>More of a documentation problem then anything else but the solution is
>in Metalink.
>
>fdp
>
>--------------------------------------------------------------------
>Fred Pierce (DNRC)- fpierce_at_avialantic.com
>Mid-Atlantic Aviation on the Web - http://www.avialantic.com
>** Mid Atlantic Air Museum WWII Weekend June 2-4 ** World Airshow News
>**
>---------------------------------------------------------------------
>
>Tony Simopoulos wrote:
>>
>> hello,
>>
>> i have made the profound mistake of upgrading from 8.1.5 to 8.1.6. i
>> chose to upgrade PL/SQL during this process.
>>
>> i have not a single package working, because of an error with
>> "SYS.STANDARD". i believe my task is to re-install PL/SQL, and
>> recreate all packages, including rdbms packages and tools packages.
>>
>> unfortunately, oracle in its infinite installer wisdom did not give me
>> an "admin" directory for plsql. using the installer again, there is
>> no way to "reinstall" plsql.
>>
>> what can i do?
>>
>> and even if i can reinstall plsql, how do i make sure every package is
>> properly recompiled? is there an inventory i can use somewhere?
>>
>> please help ...
>>
>> tonys.
Received on Tue Aug 01 2000 - 00:00:00 CDT