Sunday, September 21, 2008

Oracle Data Pump

Oracle Data Pump

Oracle Data Pump is a feature of Oracle Database 11g that enables very fast bulk data and metadata movement between Oracle databases. Oracle Data Pump provides new high-speed, parallel Export and Import utilities (expdp and impdp) as well as a Web-based Oracle Enterprise Manager interface.
Data Pump Export and Import utilities are typically much faster than the original Export and Import Utilities. A single thread of Data Pump Export is about twice as fast as original Export, while Data Pump Import is 15-45 times fast than original Import.
Data Pump jobs can be restarted without loss of data, whether or not the stoppage was voluntary or involuntary.
Data Pump jobs support fine-grained object selection. Virtually any type of object can be included or excluded in a Data Pump job.
Data Pump supports the ability to load one instance directly from another (network import) and unload a remote instance (network export).

No comments: