Re: Had problems upgrading to Oracle v804

It is not unusual that views, functions, etc. are flagged as invalid during a migration or an export/import. This just is used as an indication that the object must be reevauated before it is used (not necessarily an indication that there is a problem with the object). If you can recompile the objects without error, then there was no problem with the upgrade. You can generate a script to recompile the invalid objects, or just wait until they are accessed the first time by the application.

ALambagain wrote:

> The migrate process was too complexed and did not complete successfully. It
> wiped out all my tables the 1st time and the 2nd it left all of my view,
> functions, packages, etc invalid.
> Then I tried export form 7.2.2.4 and importing into v8.0.4. Same thing... left
> with hundreds of invalid objects.
> Call me for details at 504-842-7857 or email alamb_at_ochsner.org
> We are on 7.2.2.4.
> The upgrade was a disaster!
Received on Sun May 31 1998 - 09:33:49 CDT