If your database is too large to use the export/import method, you could try another approach, which would be to...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
upgrade your 8i database (assuming it's 22.214.171.124) directly to Oracle 10g on the Solaris server, then use the new 10g cross-platform transportable tablespaces feature to move your database across to the Linux server. Both Solaris and Linux are supported platforms (you can query the view V$TRANSPORTABLE_PLATFORM to see supported platforms) but they are of different endianness. Solaris 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.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
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
Can I use /var/opt/oracle/oratab to specify listener information?continue reading
I'm getting errors while installing the Database Configuration Assistant.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.