Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export and import performance between dmp and eif file

jmarcFeb 19 2008 — edited Feb 20 2008
hi,
Our database version is 10.2.0.3 + olap patch A.

We have an aw named EISEVAL, it size is about 2.5 Gb
If we make a schema export with exp command, it takes 45 mn
If we make an export with the command olap dml export eif format , it takes 15 mn

The main problem is for the import ,
with the command olap dml import, it takes 15 mn
with the imp command, after 24 hours, it's not finished.

I would know if somebody have observed this behaviour or can help me to improve the import with imp command.
Best regards
Jean marc
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2008
Added on Feb 19 2008
2 comments
1,513 views