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

"Noel" <tbal_at_go2.pl> wrote in message news:<bk711u$me0$1_at_inews.gazeta.pl>...
> 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 ?

Well, I think that the upgrade manual might give clues to problems with that.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96530/upgrade.htm#1009472

Not to mention 32-->64 bit changing issues.

> But I think, upgrade method its better and safe for it.
> --
> Noel

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=159657.1 is pretty good, except it doesn't directly mention about changing to LMT's.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/gallery/view_photo.php?set_albumName=week030908&id=monjohnny