Skip to Main Content
Forums

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!

old imp vs impdp

unknown-1052419Apr 13 2014 — edited Apr 15 2014

Hi all,

11.2.0.1

Before If I am importing 1Gb data using IMP, I will use  commit=Y so it will not use big UNDOTS.

But now in IMPDP, there is no such a thing. How can my IMPDP commit immediately and not use big UNDO?

Thanks,

pK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2014
Added on Apr 13 2014
#database-key-features, #export-import-sql-loader-external-tables
4 comments
2,477 views