The Oracle Database Utilitiesócomprising Oracle Data Pump and Oracle SQL*Loaderóare a set of tools to allow fast and easy data transfer, maintenance, and database administration of Oracle databases.
A D V E R T I S E M E N T
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).
SQL*Loader is a high-speed data loading utility that loads data from external files into tables in an Oracle database. SQL*Loader accepts input data in a variety of formats, can perform filtering, and can load data into multiple Oracle database tables during the same load session.
SQL*Loader provides three methods for loading data: Conventional Path Load, Direct Path Load, and External Table Load.