What are the advantages and disavantages between the Oracle upgrade (9i and 10g) and export/import (9i export and 10g import) process?
The biggest advantage to the export/import process is that you can reorganize things during your upgrade. You can precreate objects in new tablespaces and import with IGNORE=Y for instance. However, the export/import method of upgrading can be slow for large databases.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading