General discussion

Locked

import of 22 gb data in oracle

By lovely.gahlawat ·
How to import/export of table of 22GB in oracle?
Please advice, it is urgent...

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Export and Import

by virag123 In reply to import of 22 gb data in o ...

What is your oracle version and OS version ?

Virag Sharma
http://virag.sharma.googlepages.com/

Collapse -

improve performance of exp/imp , datapump expdp/impdp

by virag123 In reply to import of 22 gb data in o ...

Check following site for improve performance of exp/imp

http://orafaq.com/faqiexp.htm#SPEED

and you are on 10g then use datapump(DP), instead of using exp/imp. DP will also take advantage of multiple CPU and will run export/import in parallel

~ Virag Sharma
http://virag.sharma.googlepages.com

Back to IT Employment Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums