Re: Upgrading Questions

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Sun, 4 Jul 1999 10:54:27 -0300
Message-ID: <bxKf3.2037$jl.11732373@newscontent-01.sprint.ca>

Hi!

<bigrandyc_at_my-deja.com> wrote in message news:7ln75p$omp$1_at_nnrp1.deja.com...
> Greetings all,
>
> We are in the preliminary stages of upgrading our 7.3.2 Oracle DBMS to
> 8.0.5. Have a few questions for anyone that has done this upgrade:
>
> 1) Did your stored procedures work after the upgrade as they were, or
> did you have to make any changes to them right off?

You hdve to clean your package specification from some mistakes O7 works but O8 shows error.
1. When you use description of type of parameter at the call of procedure. 2. When you define a type after you use it.

>
> 2) Did you use an export file or a full backup to restore the data in
> the database?

full backup useless for upgrade. But it's not bad to have it if you deside return to O7.
Make export/import.

>
> My paranoia runs a little deep, so I will more than likely do a cold
> backup AND an export of the 7.3.2 database.

Its normal ... sympthom. :^)

Regards,
Mark Malakanov

>
> Thanks for any and all responses...
>
> Randy Cain
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Jul 04 1999 - 08:54:27 CDT