Oracle Database Utilities—comprising Oracle Data Pump and Oracle SQL*Loader—are a set of tools for fast and easy data transfer, maintenance, and database administration of Oracle databases.
Perform fast bulk data and metadata movement between Oracle databases using the Oracle Data Pump feature of Oracle Database Utilities. Oracle Data Pump provides high-speed, parallel Export and Import utilities, expdp and impdp, respectively and a web-based Oracle Enterprise Manager interface.
The What's New in Oracle Data Pump presentation delivered at Oracle OpenWorld discusses the new features of Oracle Data Pump, including
Make migrating and consolidating faster and easier by using the Oracle Data Pump: Full Transportable Export/Import feature. It combines the ease of use of Data Pump with the speed of transportable tablespaces.
About Oracle Data Pump:
Perform hgh-speed data filtering and loading from external files into Oracle database tables using the SQL*Loader feature of Oracle Database Utilities. Users can choose either Conventional Path, Direct Path, or External Table loading of files in a variety of formats into one or multiple Oracle tables.
Express Mode Loading with SQL*Loader in Oracle Database discusses how Express Mode can simplify loading by looking for the fastest possible mechanism and profiles its optional parameters for customizing the loading process.
Enhance the flexibility and processing power of external tables with more loadable data formats through support for user-defined preprocessing of input data.
User-defined pre-processor programs can be system commands, user-generated binaries, such as a C program, and user-supplied shell scripts, and be customized to meet the user’s specific needs. The variety of loadable formats is only limited by the ability to manipulate the original data set.