June 14, 2007

Revisit impdp

Features attract to me:

  • Data Pump Import uses the Direct Path method of loading and no manual tunning
  • Use stop_job to terminate job
  • TABLE_EXISTS_ACTION : useful but very dangerous “truncate” value.

Hongfeng Sun : 14 Jun 2007 17:08 |  Comments (0) |  Trackbacks (1) |  Report a problem

- No comments Not publicly viewable

Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Trackbacks

Trackback URL: http://blogs.warwick.ac.uk/java/entry/revisit_impdp/trackback/

  1. impdp is cool

    We have a big table need to be imported to another db. Using old style imp, it took about 1 hour to import 60K rows. Using impdp, it took one minutes to import 70K rows. expdp: two new oracle processes: ora_dmnn_sid...

    Oracle/Java/Others - 13 Dec 2007, 16:14

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested he… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Orac… by lucy on this entry
  • “logical standby failed to re–start, I am also getting … by anemia on this entry
  • thanks for give nice information for health.. by Appointment Setting on this entry
  • Thanks for the nice information because from last three days i am s… by robot vacuum on this entry
Not signed in
Sign in

Powered by BlogBuilder
© MMXII