Skip Headers

Oracle® Database Utilities
10g Release 1 (10.1)

Part Number B10825-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

What's New in Database Utilities?

This section describes new features of the Oracle Database 10g utilities and provides pointers to additional information. For information about features that were introduced in earlier releases of Oracle Database, refer to the documentation for those releases.

New Features in Oracle Database 10g


Data Pump Technology

Oracle Database 10g introduces the new Oracle Data Pump technology, which enables very high-speed movement of data and metadata from one database to another. This technology is the basis for Oracle's new data movement utilities, Data Pump Export and Data Pump Import.

See Chapter 1, " Overview of Oracle Data Pump" for more information.


Data Pump Export

Data Pump Export is a utility that makes use of Oracle Data Pump technology to unload data and metadata at high speeds into a set of operating system files called a dump file set. The dump file set can be moved to another system and loaded by the Data Pump Import utility.

Although the functionality of Data Pump Export (invoked with the expdp command) is similar to that of the original Export utility (exp), they are completely separate utilities.

See Chapter 2, " Data Pump Export" for more information.


Data Pump Import

Data Pump Import is a utility for loading a Data Pump Export dump file set into a target system.

Although the functionality of Data Pump Import (invoked with the impdp command) is similar to that of the original Import utility (imp), they are completely separate utilities.

See Chapter 3, " Data Pump Import" for more information.


Data Pump API

The Data Pump API provides a high-speed mechanism to move all or part of the data and metadata from one database to another. The Data Pump Export and Data Pump Import utilities are based on the Data Pump API.

The Data Pump API is implemented through a PL/SQL package, DBMS_DATAPUMP, that provides programmatic access to Data Pump data and metadata movement capabilities.

See Chapter 5, " The Data Pump API" for more information.


Metadata API

The following features have been added or updated for Oracle Database 10g.

See Chapter 18, " Using the Metadata API" for full descriptions of these features.


External Tables

A new access driver, ORACLE_DATAPUMP, is now available. See Chapter 15, " The ORACLE_DATAPUMP Access Driver" for more information.


LogMiner

The LogMiner utility, previously documented in the Oracle9i Database Administrator's Guide, is now documented in this guide. The new and changed LogMiner features for Oracle Database 10g are as follows:

See Chapter 19, " Using LogMiner to Analyze Redo Log Files" for more information.