Wednesday, August 8, 2012

Why you should use Oracle datapump

  • Similar look and feel to the old exp/imp
  • Can filter on the full range of object types
  • Can re-map datafiles and or tablespaces on import
  • Parallelizable
  • Significantly faster than the traditional exp/imp
  • PL/SQL interface - programmable
  • Can import through a network link
  • Tracking in V$session_longops
  • Interruptible and restartable

No comments:

Post a Comment