What are the advantages and disavantages between the Oracle upgrade (9i and 10g) and export/import (9i export and...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.