oracle 10g database migration
Home > IT Answers > Oracle > oracle 10g database migration
Inprise
540 pts.
0
Q:
oracle 10g database migration
Oracle administration, Oracle 10g, 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
ASKED: Aug 4 2009  8:29 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Inprise
540 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Aug 4 2009  8:29 AM GMT by Inprise   540 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Meandyou   1840 pts.  |   Aug 5 2009  3:01PM GMT

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.

 
0