If I recall correctly, the 8i export utility does not handle nested tables very well. For this reason, you probably won't be able to use the export/import method of migrating to your new version. Have you tried to upgrade with the DBCA? If you are moving to a new server, I would recommend migrating to the new version with the DBCA, then using export/import to move the database.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.