The Oracle Database 12c 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 is a feature of Oracle Database 12c 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.
What's New in Oracle Data Pump for Oracle Database 12c is the presentation delivered at Oracle OpenWorld 2013 in San Francisco. This presentation discusses several new features of Oracle Data Pump, including
Oracle Database 12c: Full Transportable Export/Import is a technical white paper describing the new full transportable export/import feature in Oracle Database 12c. This feature combines the ease of use from Data Pump with the speed of transportable tablespaces to make migrating and consolidating faster and easier than ever before.
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.
Express Mode Loading with SQL*Loader in Oracle Database 12c is a technical white paper that introduces a great new feature of SQL*Loader, available with Oracle Database 12c. Express mode in SQL*Loader greatly simplifies the work needed to load most data files. It tries to use the fastest mechanism possible for loading the data, and has optional parameters that allow users to customize the load.
SQL*Loader provides three methods for loading data: Conventional Path Load, Direct Path Load, and External Table Load.
A feature has been added to external tables that allows users to preprocess input data before it is sent to the access driver. The ability to manipulate input data with a preprocessor program results in additional loadable data formats, which greatly enhances the flexibility and processing power of external tables.
The types of preprocessor programs that can be used are versatile, ranging from system commands, user-generated binaries (for example, a C program), or user-supplied shell scripts. Because the user supplies the program to preprocess the data, it can be tailored to meet the user’s specific needs. This means that the number of loadable formats is restricted only by the ability to manipulate the original data set.