Home > IT Answers > Oracle > oracle 10g database migration
Inprise
610 pts.
 oracle 10g database migration
Oracle 10g, Oracle administration, Oracle migration
Hi Exprts, we migrated a database in terabytes in size in Oracle 10 g using data pump it took 10 hrs for export and 46 hrs to import i am sure this is not the efficient method can you please suggest wat possiblities there to improve the export/import to happen fast for such huge sized databases

Software/Hardware used:
ASKED: August 4, 2009  8:29 AM
UPDATED: August 5, 2009  3:01 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

IMPORT always takes longer than EXPORT. Import has to validate, verify constraints, build indices, and so on.

The only suggestion I can offer is to check the IMPORT/EXPORT parms, like buffer size, to try to improve run time.

Meandyou
 5,205 pts.