Oracle Data Pump, available with Oracle 10g http://www.oracle.com is one of the better new features of 10g and represents a major improvement on its predecessors the export/import toolset. There is considerable benefit to be gained from familiarising yourself with the Oracle Data Pump. Oracle 10g documentation suggests that as well as supporting all the functionality of the export/import toolset, Data Pump has the following new features: dump file encryption and compression, checkpoint restart, job size estimation, very flexible fine-grained object selection, direct loading of one instance from another, detailed job monitoring, and the ability to move individual table partitions using transportable tablespaces. In my opinion the three key advantages of Oracle Data Pump over the export/import toolset are: Faster Performance, Improved Manageability and Fine-Grained Object Selection. The numerous advantages of Data Pump coupled with the fact that the export utility is being deprecated with the Oracle Database 11g release (the Import utility will always be supported so that dump files from earlier releases will be able to be imported), means there is very little reason to still be using the export/import toolset.
Continue reading ‘Oracle Data Pump, a big improvement for data movement.’
Technorati Tags: 11g