Oracle Data Pump Key Features
Oracle Data Pump is a new and unique feature of Oracle Database 11g. A new public interface package, DBMS_DATAPUMP, provides a server-side infrastructure for fast data and metadata movement between Oracle databases. It is ideal for large databases and data warehousing environments, where high-performance data movement offers significant time savings to database administrators.
Data Pump automatically manages multiple, parallel streams of unload and load for maximum throughput. The degree of parallelism can be adjusted on-the-fly. There are new and easy-to-use Export and Import utilities (expdp and impdp), as well as a web-based Enterprise Manager export/import interface.
Data Pump is an integral feature of Oracle Database 11g and is available in all configurations. However, parallelism is available only in Enterprise Edition.
Key Features Fast Performance
Operations performed with the new Data Pump Export and Import utilities are typically much faster than operations performed with the original Export and Import utilities. With Data Pump Export, when the direct path method of unloading is used, a single stream of data unload is about two times faster than original Export. This is because the direct path API has been modified to be even more efficient than before. Depending on the level of parallelism, the performance improvement can be even greater.
With Data Pump Import, a single stream of data load is about 15-45 times faster than original Import. This is because original Import uses only conventional mode inserts, whereas Data Pump Import uses the direct path method of loading. As with Export, the performance improvement can be even greater depending on the level of parallelism.
No database tuning is required to achieve maximum Data Pump performance. The initialization parameters should be sufficient out of the box.
Improved Management Restart
Every Data Pump operation has a master table that is created in the schema of the user running a Data Pump
Data Pump automatically manages multiple, parallel streams of unload and load for maximum throughput. The degree of parallelism can be adjusted on-the-fly. There are new and easy-to-use Export and Import utilities (expdp and impdp), as well as a web-based Enterprise Manager export/import interface.
Data Pump is an integral feature of Oracle Database 11g and is available in all configurations. However, parallelism is available only in Enterprise Edition.
Key Features Fast Performance
Operations performed with the new Data Pump Export and Import utilities are typically much faster than operations performed with the original Export and Import utilities. With Data Pump Export, when the direct path method of unloading is used, a single stream of data unload is about two times faster than original Export. This is because the direct path API has been modified to be even more efficient than before. Depending on the level of parallelism, the performance improvement can be even greater.
With Data Pump Import, a single stream of data load is about 15-45 times faster than original Import. This is because original Import uses only conventional mode inserts, whereas Data Pump Import uses the direct path method of loading. As with Export, the performance improvement can be even greater depending on the level of parallelism.
No database tuning is required to achieve maximum Data Pump performance. The initialization parameters should be sufficient out of the box.
Improved Management Restart
Every Data Pump operation has a master table that is created in the schema of the user running a Data Pump