Create an Oracle 10g database on your Linux server, export your Oracle9i database, FTP the .dmp file over to the Linux server and import it into your newly created database.
- Create Table As Select (CTAS) via a Database Link
Create an Oracle 10g database on your Linux server and create a database link from the Oracle 10g database to the Oracle9i database. Run 'create table as select …' statements to create your tables with the data in the Oracle 10g database. Remember to also create any required indexes and constraints.
- Use Oracle 10g Cross-platform Transportable Tablespaces
Upgrade your Oracle9i database to Oracle 10g on the HPUX server and then use the new cross-platform transportable tablespaces feature to move your database to your Linux server. Both HPUX and Linux are supported platforms (you can query the view V$TRANSPORTABLE_PLATFORM to see supported platforms) but they are of different endianness. HPUX is big endian while Linux is little endian so there is an additional step involved to convert the tablespaces being transported on either the source or target side.
To read more about the cross-platform transportable tablespace feature, download the Oracle Database Administrator's Guide 10g (release 10.2) from Oracle Technology Network. The guide can be found here.
You should also review the Oracle Database 10g Release 2 (10.2) Upgrade Guide which can be found here.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading