This section describes new features of the Oracle Database 11g 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.
This section lists the major new features that have been added for Oracle Database 11g Release 1 (11.1).
For the Data Pump Export and Data Pump Import products, new features have been added that allow you to do the following:
Compress both data and metadata, only data, only metadata, or no data during an export. See COMPRESSION.
Specify additional encryption options in the following areas:
You can choose to encrypt both data and metadata, only data, only metadata, no data, or only encrypted columns during an export. See ENCRYPTION.
You can specify a specific encryption algorithm to use during an export. See ENCRYPTION_ALGORITHM.
You can specify the type of security to use for performing encryption and decryption during an export. For example, perhaps the dump file set will be imported into a different or remote database and it must remain secure in transit. Or perhaps the dump file set will be imported onsite using the Oracle Encryption Wallet but it may also need to be imported offsite where the Oracle Encryption Wallet is not available. See ENCRYPTION_MODE.
Perform table mode exports and imports using the transportable method. For information on using this feature during export, see the export TRANSPORTABLE parameter. For information on using this feature during import, see the import TRANSPORTABLE parameter.
Specify how partitioned tables should be handled during import operations. See PARTITION_OPTIONS for a description of using this parameter during an import.
Overwrite existing dump files during an export operation. See REUSE_DUMPFILES.
Rename tables during an import operation. See REMAP_TABLE.
Specify that a data load should proceed even if non-deferred constraint violations are encountered. This is valid only for import operations that use the external tables access method. See the import DATA_OPTIONS parameter.
Specify that XMLType columns are to be exported in uncompressed CLOB format regardless of the XMLType storage format that was defined for them. See the export DATA_OPTIONS parameter.
During an export, specify a remap function that takes as a source the original value of the designated column and returns a remapped value that will replace the original value in the dump file. See the export REMAP_DATA parameter.
During an import, remap data as it is being loaded into a new database. See the import REMAP_DATA parameter.
Automatic restart of workers on the same instance.
Additionally, Data Pump will now perform a one-time automatic restart of workers (on the same instance) that have stopped due to certain errors. For example, if someone manually stops a process, the worker is automatically restarted one time, on the same instance. If the process stops a second time, it must be manually restarted.
For the External Tables functionality, the following new features have been added:
Ability to compress data before it is written to the dump file set. See COMPRESSION.
Ability to encrypt data before it is written to the dump file set. See ENCRYPTION.
LogMiner now provides the following additional support:
The LogMiner utility now supports
XMLType data when it is stored in
The Automatic Diagnostic Repository Command Interpreter (ADRCI) provides a way for you to work with the diagnostic data contained in the Automatic Diagnostic Repository (ADR). The ADR is a file-based repository for database diagnostic data, such as traces, dumps, the alert log, health monitor reports, and more. It has a unified directory structure across multiple instances and multiple products.
See Chapter 15, "ADRCI: ADR Command Interpreter" for more information.
The Enterprise Manager Configuration Assistant (EMCA) is now documented in this book. Prior to Oracle Database 11g Release 1, it was documented in Oracle Enterprise Manager Advanced Configuration. The EMCA provides a command-line interface for configuring Database Control.
See Chapter 21, "Enterprise Manager Configuration Assistant (EMCA)" for more information.