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.

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

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.