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@xxxxxxxxxxx x72546 904 727-2546 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dan Norris Sent: Monday, June 25, 2007 9:39 PM To: tim@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx; gulzar.arif@xxxxxxxxx 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 ----- Original Message ---- From: Tim Gorman <tim@xxxxxxxxx> To: dannorris@xxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx; gulzar.arif@xxxxxxxxx Sent: Monday, June 25, 2007 4:44:59 PM Subject: Re: migrating 9i/HP-UX DB to 10g/Solaris 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 ----- Original Message ---- From: Arif Gulzar <gulzar.arif@xxxxxxxxx> <mailto:gulzar.arif@xxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx 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.