The dump file may not work. The rule of thumb when going from a higher version to a lower version is to use the lower version's export and import utilities. You may have some success in importing as it currently stands, but you may run into problems. The only way to know for sure is to try it. If it doesn't work, then re-export with the 8i utility. It will import into the 8i database just fine.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.