Re: Internal error after upgrade to 8.1.7.4

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Mon, 26 Apr 2004 16:54:52 GMT
Message-ID: <w9bjc.19011$en3.17895@edtnps89>

Gerold Krommer wrote:

> Yes. Used to be a 7.1 database back in 1996.
>
> Thanks,
>
> /Gerold

As I said, I've seen a number of databases that were upgraded from 7.x where the DBA did not closely check the results of the upgrade scripts and the catalog was progressively more corrupted with each upgrade, resulting in ORA-600's. Seems to have cleared up after running the complete catalog & catproc scripts in 8.1.7 (twice for some reason).

<aside>
Note that things have changed dramatically since 7.1 For example, in those days we used a lot of code tables that now could be streamlined using IOTs.

While your app may be satisfactory using the older technology, you may want to look at creating a fresh database in your target version (preferrably 9.2) and migrating manually rather than upgrading. Many of these changes do not involve any app change - strictly at the dictionary/dba level.

Suggest reading Tom Kyte's "Expert One-on-one Oracle" book to get a handle on some of the more interesting changes. </aside> Received on Mon Apr 26 2004 - 11:54:52 CDT