If your database is small then export/import may be more appropriate as you can create all the tablespaces to be locally managed with assm features enabled. You should be able to export from 8i client and import using 10g client onto your 10g database.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Harish Harbham
SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server. Continue Reading
Oracle expert Harish Harbham explains how Oracle Streams can be used for replication. Continue Reading
Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?" 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.