If you were using Oracle 10g, then there is another option available to you. Oracle 10g added new Data Pump utilities...
which can basically be thought of as export/import on steroids. One of the nice features of the Data Pump utilities is that you can export from one database and import directly to another through your network. This saves you the step of actually creating a dump file. This sounds like it would help you out and might actually be enough of a reason for you to upgrade to 10g.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.