The only other option would be to export/import a table or two at a time. You'd have to determine which one is faster by testing both. However, I feel that the ALTER TABLE MOVE method is probably less risky since it doesn't include a DROP TABLE in the procedure (as you would need to do for export/import).
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Dan Norris
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.