| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Had problems upgrading to Oracle v804
A copy of this was sent to alambagain_at_aol.com (ALambagain)
(if that email address didn't require changing)
On 31 May 1998 08:57:27 GMT, you 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!
Invalid objects are not a problem -- they are supposed to get that way after an upgrade or an export. They will recompile themselves as they are used or you can use dbms_utility.compile_schema to recompile each schema if you want.
With the upgrade you reinstalled the package STANDARD. by doing this you invalidated each and every package/procedure/function in the database. All views are forced invalid to get them to recompile after an upgrade.
With an export, things are created in some order and that order does not gaurantee that all things needed to support an object exist as create time. therefore many objects will be invalid after an import. but again -- thats the way it is supposed to be.
After for wiping out all tables with the first upgrade, it sounds like you might have asked for the starter database to be installed.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun May 31 1998 - 08:23:02 CDT
 |
 |