Entering content frameFunction documentation Parallel Export and Import Locate the document in its SAP Library structure

Use

You can perform parallel export and import in SAPDBA for Oracle to speed up processing.

Prerequisites

The exp_imp_degree parameter determines the degree of parallelism for the export or import. The default value for this parameter is 1.

Parallel export and import is only relevant if you are:

Integration

If you are using the export/import reorganization method to reorganize more than one table or index, you can perform parallel export and import. For more information, see Performing Processes in Parallel to Speed Up Reorganization.

Features

Sequential Export and Import with exp_imp_degree = 1

If you do not change the default value for exp_imp_degree , all export and import processes are executed sequentially. SAPDBA suggests the <timestamp> directory created in <SAPDATA_HOME>/sapreorg as the target for the export dump files. For more information, see the exireo_dumpdir parameter.

Parallel Export and Import with exp_imp_degree > 1

If several export dump files are to be created, then the export or import can be executed in parallel if you:

Parallel Processing

SAPDBA generates one export dump file for each parallel process, distributing the tables to the individual export dump files on the basis of their size, to ensure that the files all have approximately the same size. However, SAPDBA also takes the size of the file systems or tapes into account.

SAPDBA assigns parallel processes as follows:

You can compress the export dump files in all the directories on disk while using parallel processing. However, the compress option has no effect when exporting to tape, for which you must use hardware compression instead.

 

See also:

Leaving content frame