What's New in Database Utilities?

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.

New Features in Oracle Database Utilities 11g Release 2

This section lists the major new features that have been added for Oracle Database 11g Release 2 (11.2).

Data Pump Export and Data Pump Import

• Data Pump provides a legacy mode in which you can use original Export and Import parameters when performing Data Pump Export and Import operations. See Chapter 4, "Data Pump Legacy Mode" for more information.

• The restriction that in Tables mode all tables had to reside in the same schema has been removed. You can now specify tables in multiple schemas.

• The restriction that only one object (table or partition) could be specified if wildcards were used as part of the object name has been removed. You can now specify multiple tables and partitions and use wildcards in all of them.

• Data Pump worker processes can be distributed across Oracle Real Application Clusters (RAC) instances, a subset of Oracle RAC instances, or confined to the instance where the Data Pump job is started. It is also now possible to start Data Pump jobs and run them on different Oracle RAC instances simultaneously. See the Export CLUSTER parameter and the Import CLUSTER parameter .

• Specific editions can be exported and imported. See the Export SOURCE_EDITION parameter and the Import TARGET_EDITION parameter.

• When performing an import operation, you can use the new DISABLE_APPEND_HINT value on the DATA_OPTIONS parameter to specify that you do not want the import operation to use the APPEND hint while loading the data object. See the Import DATA_OPTIONS parameter.

External Tables

• The ORACLE_LOADER access driver has been enhanced to allow the specification of a user-supplied preprocessor program that will read data from a file that is not in a format supported by the driver. See PREPROCESSOR.

Original Export

• In Oracle Database 11g release 2 (11.2), the DEFERRED_SEGMENT_CREATION parameter is set to TRUE by default. This means that any tables you create will not have any segments until the first row of data is inserted into the table. Original export ignores tables without segments. Therefore, if you create any new tables and do not insert any data before performing an export, those tables will not be exported. (Note that Data Pump Export does not have this limitation because it does not ignore tables without segments.)

Other Utilities

• A new PL/SQL package, DBMS_METADATA_DIFF, allows you to compare the metadata for two SQL objects (tables, indexes, and so on) and get the following information in return:

  • An XML document showing the metadata for both objects, including the ways they are the same and the ways they are different

  • A set of ALTER statements to make one object like the other

  Use of this package requires the Oracle Enterprise Manager Change Manager license.

  See Also:

  • Oracle Database PL/SQL Packages and Types Reference for a description of the DBMS_METADATA_DIFF API

  • Chapter 20, "Using the Metadata APIs"

New Features in Oracle Database Utilities 11g Release 1

This section lists the major new features that have been added for Oracle Database 11g Release 1 (11.1).

Data Pump Export and Data Pump Import

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 on-site 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.

External Tables

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 Utility

LogMiner now provides the following additional support:

• The LogMiner utility now supports XMLType data when it is stored in CLOB format.

See Supported Datatypes and Table Storage Attributes.

Automatic Diagnostic Repository Command Interpreter (ADRCI)

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 16, "ADRCI: ADR Command Interpreter" for more information.

Enterprise Manager Configuration Assistant (EMCA)

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 23, "Enterprise Manager Configuration Assistant (EMCA)" for more information.