Re: Does a db upgrade change the SQL parser ?

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Tue, 23 Jul 2002 10:31:12 +0100
Message-ID: <Bn9%8.4086$zX3.3279@news.indigo.ie>

Yes. it changed. some statements may indeed generate different plans.

Most people here who have upgraded have sometimes been pleasantly or unpleasantly surprised by this.

This is the same whether 817 ->92 or 805 ->817. Keep going on the upgrade ! go to 9.2 and be current ...
have you all the 817 patches ?

ORA980 means there's something missing

"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:ahj40b$tetn1$1_at_ID-152732.news.dfncis.de...
> Hello,
>
> we have just upgraded our db from 8.0.5 to 8.1.7, and now some SQL- and
> Forms Developers start
> complaining about a changed SQL parsing behavior. It affected only a few
> statements over all,
> but they can show me some different Explain Plans and some error messages
> for statements
> that were compiled without problems before.
> And, although a public synonym is still there, with all privilges needed,
we
> somtimes see
> "ORA-00980 synonym translation is no longer valid". This is only the case
of
> a (large) table in a
> schema (lets say "Y"), while most of our tables are in schema "X".
>
> Is there anybody here who has some experience with db upgrading, who has
> made some similar
> observations ?
>
> ThanX in advance,
> Jan
>
>
Received on Tue Jul 23 2002 - 04:31:12 CDT