Oracle Database 11g Oracle Database Utilities

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.

Technical Information
Oracle Data Pump
Data Pump Overview (HTML) Updated
Data Pump Feature Overview (PDF 150KB) New
Data Pump Technical White Paper (PDF 199KB) Updated
Parallel Capabilities of Oracle Data Pump (PDF 122KB) Updated
Data Transformations With Oracle Data Pump (PDF 127KB) New
Oracle Data Pump: Quick Start (PDF 142KB) Updated
Data Pump FAQ (HTML) Updated

SQL*Loader
SQL*Loader Overview

 
Left Curve
Learn More
Right Curve
 · Oracle Data Pump: Quick Start Updated
 · Parallel Capabilities of Oracle Data Pump Updated
 · Top Oracle Database 10g Features for DBAs: Oracle Data Pump
 · Oracle University: Oracle Database 10g New Manageability Features
 · Oracle 10g Data Pump Overview Presentation (ZIP)
 · Oracle By Example Hands-on Tutorials

Left Curve
Discussion Forums
Right Curve
 · Database
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy