oracle-db12c-logo      Oracle Database Utilities

 


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


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

  • Full transportable export/import (see white paper described below)
  • Exporting views as tables
  • Detailed timestamps for Data Pump operations
  • Security enhancements
  • Enhanced compression options
  • Additional TRANSFORM options


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.

  • 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.

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.

External Tables


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.




Technical Information



Oracle Database 11g Release 2


Oracle Data Pump



External Tables



SQL*Loader





Presentations & Webcasts



Oracle OpenWorld


 

Webcasts





Discussion Forums




In-Memory Replay Banner