One option is using export full with no rows and import full witihout rows
to generate the database structure so you dont have to worry abour grants,
after that just run several parallel imports per schema
thanks
--
LSC
On 10/17/07, development_at_the-playground.de <development_at_the-playground.de>
wrote:
>
> Thanks all for your valuable suggestions!
>
> Since we are on Solaris 7 I can't have an Oracle 10.2 installation and
> benefit from transportable tablespaces.
>
> I think I'll end up doing a user export (exp 8.1.5 -> pipe -> imp 10.2
> via network) for the schemas containing data. This can easily be
> parallelised by running a few exports and imports simultaneously. I was
> surprised to find that in Metalink note 132904.1 it reads that
> fromuser/touser will work.
>
> Additional things to take care of are
> - sys grants
> - other user accounts
> - 32 to 64 conversion (the new empty database on AIX is 64 bit)
>
> And as usual, test, test, test.
>
> Cheers,
>
> Martin
>
> Am 16.10.2007 um Uhr haben Sie geschrieben:
> >
> > Would not call them "exotic", just a darn lot faster & less error
> prone.
> >
> >
> >
> > ______________________________________________________________
> > Dick Goulet / Capgemini
> > North America P&C / East Business Unit
> > Senior Oracle DBA / Hosting
> > Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com
> > Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com
> > 45 Bartlett St. / Marlborough, MA 01752
> >
> > Together: the Collaborative Business Experience
> > ______________________________________________________________
> >
> > ________________________________
> >
> > From: LS Cheng [mailto:exriscer_at_gmail.com]
> > Sent: Tuesday, October 16, 2007 2:36 PM
> > To: Goulet, Dick
> > Cc: zimsbait_at_gmail.com; development_at_the-playground.de;
> > oracle-l_at_freelists.org
> > Subject: Re: 8.1.5 upgrade paths to 10.2.x
> >
> >
> >
> > with a 60gb database I wouldnt mess around with the exotic ways...
> >
> >
> >
> >
> >
> >
> >
> > On 10/16/07, Goulet, Dick <richard.goulet_at_capgemini.com> wrote:
> >
> >
> > Better idea, which I've done recently. Upgrade DB to 8.1.7 then to
> > 10.2, approximate time 3 hours. Then use Transportable database to
> move
> >
> > datafiles to AIX, convert them with RMAN & restart your db. This
> entire
> > process on HP-UX to AIX took 18 hours total for a 700GB database.
> Would
> > have been faster if we had paralleled things.
> >
> > ______________________________________________________________
> > Dick Goulet / Capgemini
> > North America P&C / East Business Unit
> > Senior Oracle DBA / Hosting
> > Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com
> > Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com
> > 45 Bartlett St. / Marlborough, MA 01752
> >
> > Together: the Collaborative Business Experience
> > ______________________________________________________________
> >
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of z b
> > Sent: Monday, October 15, 2007 3:53 PM
> > To: development_at_the-playground.de
> > Cc: oracle-l_at_freelists.org
> > Subject: Re: 8.1.5 upgrade paths to 10.2.x
> >
> > To "parallelize" you could use limit the dump files to, say, 500MB
> > dump files. (filesize parameter)
> >
> > Ftp the files and start the import while the export is still running.
> >
> > Of course - test a couple of times before actually scheduling. :)
> >
> >
> > On 10/15/07, development_at_the-playground.de
> > < development_at_the-playground.de <mailto:development_at_the-playground.de>
> >
> > wrote:
> > > Hello group!
> > >
> > > I have got a tricky problem at hand - migrate an Oracle 8.1.5 on
> > Solaris
> > > 7 database to 10.2.0.x on AIX. The problem here is that I am not
> > allowed
> > > much downtime. Having started with Oracle 8i I am not too sure how
> > that
> > > can be done. Obviously to get from 8.1.5 I have to go to 8.1.7
> first,
> > a
> > > direct update is supported which is good. I am thinking of a new
> > Oracle
> > > home on the same machine, copying the database and migrating it.
> > >
> > > From there on I don't see any other way than exp/imp using pipes for
> > > faster processing. It is a bit of a mystery how I can keep the
> > downtime
> > > low, the database is some 60GB in size btw.
> > >
> > > Thanks for any input on this,
> > >
> > > Martin
> > >
> > >
> > >
> > >
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> > This message contains information that may be privileged or
> confidential
> > and is the property of the Capgemini Group. It is intended only for
> the
> > person to whom it is addressed. If you are not the intended recipient,
> > you are not authorized to read, print, retain, copy, disseminate,
> > distribute, or use this message or any part thereof. If you receive
> this
> > message in error, please notify the sender immediately and delete all
> > copies of this message.
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> >
> >
> >
> >
> > This message contains information that may be privileged or
> confidential and is
> > the property of the Capgemini Group. It is intended only for the
> person to whom
> > it is addressed. If you are not the intended recipient, you are not
> authorized
> > to read, print, retain, copy, disseminate, distribute, or use this
> message or
> > any part thereof. If you receive this message in error, please notify
> the
> > sender immediately and delete all copies of this message.
> >
> >
>
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 17 2007 - 07:05:27 CDT
