Re: 8.1.6 with 7.3.4 datafiles

1. Read the documentation
2. Read the documentation. But basically, you create a database under 8.1.6, and import the 7.3.4 export into it. You don't need to bother with the migrate tool with this route. The export is basically the SQL to create the schemas and data (and the information to make the tablespaces, which I advise you do yourself before the import).

It can take anything from an hour or two to a couple of days depending on how large the database is...

"JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0107112137.3bbd0a17_at_posting.google.com...
> there are two option.
> 1. Use migration utility to migrate data from 7.3.4 to 8.1.6.
> Migration does the least work possible to make the datafiles readable
> by 8.1.6?
>
> 2. Export/Import Utility. How to import data for upgraded version
> database server. After I install the 8.1.6, should I create a new
> database and then import data from 7.3.4? or Just import whole
> database and the 7.3.4 database will be upgraded to 8.1.6
> automatically? Or should I migrate data first and export and import
> database after that?
>
> Please clarify, thanks a lot.
>
> JK
> Jr. DBA, MMI, TW
>
>
> "andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message
 news:<994844072.4472.0.nnrp-12.c30bdde2_at_news.demon.co.uk>...
> > migration does the least work possible to make the datafiles readable by
 O8.
> > export/import will fix your annoying problems like row migration and you
> > will get your indexes rebuilt (and in the proper O8 manner). It's a good
> > time to sort out some of the flaws that came to light over the years...
> >
> > "JK Yao" <jkyf0131_at_hotmail.com> wrote in message
> > news:93f65984.0107101916.16f5842_at_posting.google.com...
> > > What's the different between Export/Import Utility and Migration
 Utility.
> > > Which one will be better? Thanks.
> > >
> > > JK
> > >
> > >
> > > frank seuberth <frank.seuberth_at_consors.de> wrote in message
 news:<3B4B1337.744567D6_at_consors.de>...
> > > > I strongly recumend Export / Import (Conventional PATH)
> > > > Frank
> > > >
> > > > JK Yao schrieb:
> > > >
> > > > > dear all,
> > > > >
> > > > > Our company is goint o upgrade from 7.3.4 to 8.1.6.
> > > > > After install the 8.1.6. Can I just use the datafiles from 7.3.4
> > > > > without move those files? So, if yes, should I just create
 database
> > > > > with the same datafile locations.
> > > > >
> > > > > JK
> > > > > Jr. DBA, MMI
> > >
Received on Sat Jul 21 2001 - 16:32:41 CDT