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