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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: migrating 9i/HP-UX DB to 10g/Solaris

Re: migrating 9i/HP-UX DB to 10g/Solaris

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Mon, 25 Jun 2007 15:34:29 -0700 (PDT)
Message-ID: <287416.12930.qm@web38911.mail.mud.yahoo.com>


Either way works. Transportable tablespace is probably best for larger databases if you can upgrade first. Dan's export/import suggestion is great for smaller databases (I suggest you enable and monitor resumable space management!!)

go go gaget transportable tablespace!

RF
--- Syed Jaffar Hussain <sjaffarhussain_at_gmail.com> wrote:

> If the database is upgraded to 10gR2, cross platform
> database conversion
> would be handy than the transport tablespaces.
>
>
> On 6/25/07, Dan Norris <dannorris_at_dannorris.com>
> wrote:
> >
> > If it is a small database, I'd probably use export
> 9i -> import 10g. If
> > it's got any significant size, I'd consider
> upgrading to 10g on HPUX, then
> > use transportable tablespaces to Solaris/10g.
> >

Robert G. Freeman
Author:
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Oracle Replication (Rampant Tech Press)
Mastering Oracle8i (Sybex)
Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>) Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 25 2007 - 17:34:29 CDT

Original text of this message

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