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: Migrate to 8.05!

Re: Migrate to 8.05!

From: Glen Upreti <glen.upreti_at_nau.edu>
Date: Thu, 14 Jan 1999 13:44:21 -0700
Message-ID: <369E5725.F63E6B5F@nau.edu>


I migrated a number of 73x database to 805 using the migration utility (on solaris 251) and had a great time, read the book, there are a couple gotcha's like it tells you to do a select before it tells you to start it up! But it was a good experience. I did also do it with 804 and that was a real pain in the butt. The migration was so bad that I waited until the app that was using that db was certified with 805 to migrate. Good Luck,
Glen

Alan Stephenson wrote:
>
> Hello,
>
> We migrated to 8.0.5 from 7.1.6.2.0. Actually, I took a database from 7.1.6.2.0
> and upgraded to 7.3.4.0.0. I then backed up the database and performed the
> migration. I did this on Monday of this week and so far everything seems okay.
>
> I was scared at first, but since I was doing the migration on a non-critial
> database I felt a little better. I opted to first perform the migration
> assistant provided by Oracle. I am not sure if the export/import would be any
> different, but I figured I would try this one first.
>
> One concern I did have was ROWID. In the migration book it states if you use
> ROWID you might need to convert. However, so far it appears everything went
> okay. One thing we are still looking at is making sure all the data dictionary
> tables were done.
>
> If you wish to speak more, feel free to call. I would be happy to talk to you.
> If not, I wish you luck.
>
> Regards,
>
> -Alan Stephenson
>
> Yeung Man wrote:
>
> > Hi,
> >
> > Our company want to migrate the database from 7.3.2.3 to 8.05. I know
> > there are two method to migrate. One is full database export/import, another
> > is using the migration assistant provided by oracle. Is there any other
> > method? What is the adv/disadv of these two method? We don't decide use
> > which method now, please give some comment on these two method. TIA.
> >
> > Best Regards,
> > Man
> > ynmg_at_chowsangsang.com

--
<html>
<font face="Tahoma"
size=1>|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-|<br> Glen
Upreti<x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</x-tab>&nbsp;&nbsp;&nbsp;&nbsp; <br>
Oracle
DBA<x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</x-tab><x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</x-tab>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>
Northern Arizona University<br>
Phone: (520)523-8393&nbsp;
<x-tab>&nbsp;&nbsp;</x-tab>Fax:(520)523-7407<br> Glen.Upreti_at_nau.edu<br>
</font></html> Received on Thu Jan 14 1999 - 14:44:21 CST

Original text of this message

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