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> 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.