What is the maximum size for export/import migrations--MB/GB/TB?
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.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.