What is the maximum size for export/import migrations--MB/GB/TB?
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
In my experience, export/import is efficient from MB to several GB (10GB) and not more. The export and import process in this case takes 1 to 3 hours, depending on the strength of the Oracle machine. Usually when you do export/import, you move your schema to production and this process takes time. In cases where the database is bigger than several GB (Terabytes), don't use export/import, use cold backups.
Dig Deeper on Oracle database export, import and migration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.