Q

Export/import migrations

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.


This was first published in July 2001

Dig deeper on Oracle database export, import and migration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close