| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: migrating 9i/HP-UX DB to 10g/Solaris
I believe upgrading to 10g may very well be required to perform
cross-platform transportable tablespaces. However, it would probably
be faster. Is is not limited by ASM. Your going to be upgrading
anyway with export/import, so manual upgrade is not necessarily an
ordeal. Note: 316889.1
Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dan Norris
Sent: Monday, June 25, 2007 9:39 PM
To: tim_at_evdbt.com
Cc: oracle-l_at_freelists.org; gulzar.arif_at_gmail.com
Subject: Re: migrating 9i/HP-UX DB to 10g/Solaris
It's a 10g DB feature, not an ASM feature, so no, it doesn't require ASM. Regular filesystem files can be migrated just the same as ASM storage. In fact, for most people, migrating filesystem files is probably quite a bit easier :).
Dan
Using transportable tablespaces across platforms (i.e. HP-UX to Solaris) is only possible with ASM, no? So, to follow your recommendation, wouldn't he also have to add a step to migrate from file-system to ASM after upgrading to Oracle10g? Not a trivial undertaking...
...2 more pesos....
Dan Norris 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.
Just my 2 pesos.
Dan
To: oracle-l_at_freelists.org
Sent: Monday, June 25, 2007 2:35:27 PM
Subject: migrating 9i/HP-UX DB to 10g/Solaris
I have been assigned to do best option to migrating 9i/HP-UX DB to 10g/Solaris, any body can forward me the step by step instructions to accomplish this, in both cases if the DB size is small/big.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 26 2007 - 08:46:01 CDT
 |
 |