Oracle Data Pump

Page 114

Oracle Database 10g comes with a number of new features that are designed to improve data warehouses, data marts, and operational data stores. Also, several features that existed in earlier versions of Oracle Database have new features added to them. This chapter discusses several new and enhanced features, including:

Oracle Data Pump (previously exp and imp)

Bigfile tablespaces

Cross-platform transportable tablespaces

External table unload

Enhanced table functions

Enhanced merge functionality

Materialized view and query rewrite changes

Partitioning new features

Oracle Database 10g offers new and improved support for logical extracts of data in the form of Oracle Data Pump. This section introduces several topics related to Oracle Data Pump:

The Oracle Data Pump architecture

The data dictionary views associated with Oracle Data Pump

The new interactive mode available with Oracle Data Pump

The Oracle Data Pump API

Oracle Data Pump Export and Import

Oracle Data Pump Architecture

Oracle Database 10g introduces the new Data Pump infrastructure. A major part of this infrastructure replaces the imp (import) and exp (export) programs in previous versions of Oracle Database. The new Data Pump architecture is designed to provide significant performance increases over the previous imp and exp utilities. Data Pump provides new methods of moving data between databases, including the use of specially formatted files (as was the case with imp/exp) as well as a new network