Re: V7.0 -> V7.1 any problems?

From: <briantc_at_delphi.com>
Date: 1995/04/19
Message-ID: <h2zeRyo.briantc_at_delphi.com>#1/1


Stephan Okhuijsen <okhuijsen_at_twice.nl> writes:  

>We need to upgrade our version 7.0.16 RDBMS to version 7.1.4
>It's on a ICL DRS6000 with a sparc. Unix V 7.2
>Can this be done without any trouble, or are there certain things wich could
>go wrong.
>Comment and suggestions needed!
   

We've always followed the same upgrade procedure and it seems to work quite well - even upgrading from V6 to V7.  

  1. Create a brand new database under your new oracle version
  2. Export from the old one and import to the new one
  3. Switch your users accross as and when you feel the need.

We've been doing this now to switch versions for a number of years and have yet to encounter any serious problems.  

The only "nasty" we've found so far when going from 7.0.16 to 7.1 is with stored procedures - the syntax and structure checking is far stricter under 7.1 - some of the stunts your developers got away with under 7.0.16 may no longer be valid. But then again that's their problem.....  

Oracle accept it's a bug in 7.0.16 - it's not as tough on you as it should be.  

Best of Luck  

BC Received on Wed Apr 19 1995 - 00:00:00 CEST

Original text of this message