Database Reference
In-Depth Information
You can also modify the degree of parallelism while the job is running. First, attach in the interactive command
mode to the job (see the section “Interactive Command Mode,” later in this chapter) for which you want to modify the
degree of parallelism. Then, use the PARALLEL option. In this example the job attached to is SYS_IMPORT_TABLE_01 :
$ impdp mv_maint/foo attach=sys_import_table_01
Import> parallel=6
You can check the degree of parallelism via the STATUS command:
Import> status
Here is some sample output:
Job: SYS_IMPORT_TABLE_01
Operation: IMPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 6
Note
the PARALLEL feature is only available in the enterprise edition of Oracle.
Specifying Additional Dump Files
If you run out of space in the primary data pump location, then you can specify additional data pump locations
on the fly. Use the ADD_FILE command from the interactive command prompt. Here is the basic syntax for adding
additional files:
ADD_FILE=[directory_object:]file_name [,...]
This example adds another output file to an already existing Data Pump export job:
Export> add_file=alt2.dmp
You can also specify a separate database directory object:
Export> add_file=alt_dir:alt3.dmp
Reusing Output File Names
By default, Data Pump doesn't overwrite an existing dump file. For example, the first time you run this job, it will run
fine because there is no dump file named inv.dmp in the directory being used:
$ expdp mv_maint/foo directory=dp_dir dumpfile=inv.dmp
 
 
Search WWH ::




Custom Search