Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i ----> 9i Upgrade on Solaris

Re: Oracle 8i ----> 9i Upgrade on Solaris

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 16 Sep 2003 07:32:12 -0700
Message-ID: <1063722718.625119@yasure>


Noel wrote:

>Uzytkownik "Ed" <ed_zep_at_ntlworld.com> napisal w wiadomosci
>news:58e9f9da.0309151205.4a0581af_at_posting.google.com...
>
>
>>Hi.
>>
>>We're moving from Oracle 8.1.7.4 to Oracle 9.2.0.4 (64-bit) on Sun
>>Solaris 2.8.
>>
>>
>
> Import and export may take a ages of time.
> I wonder if it's possible, shut down the 8.1.7 instance, do a full backup,
> install a blank 9.2.0.4 and just move all the data files of 8.1.7,
>including init.ora and controlfiles, etc
> replacing those from 9.2.0.4 and then start up 9.2.0.4 database ?
> But I think, upgrade method its better and safe for it.
> --
> Noel
>
>

Why does everyone want to move the data? Why not just simply upgrade the thing as and where it is? Both
faster and simpler.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Sep 16 2003 - 09:32:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US