Default: current job in user's schema, if there is only one running job.
Syntax and Description
schema_name if the schema to which you are attaching is not your own. You must have the
DATAPUMP_IMP_FULL_DATABASE role to do this.
job_name does not have to be specified if only one running job is associated with your schema and the job is active. If the job you are attaching to is stopped, then you must supply the job name. To see a list of Data Pump job names, you can query the
DBA_DATAPUMP_JOBS view or the
When you are attached to the job, Import displays a description of the job and then displays the Import prompt.
When you specify the
ATTACH parameter, the only other Data Pump parameter you can specify on the command line is
If the job you are attaching to was initially started using an encryption password, then when you attach to the job you must again enter the
ENCRYPTION_PASSWORD parameter on the command line to re-specify that password.
You cannot attach to a job in another schema unless it is already running.
If the dump file set or master table for the job have been deleted, then the attach operation fails.
Altering the master table in any way can lead to unpredictable results.
The following is an example of using the
> impdp hr ATTACH=import_job
This example assumes that a job named
import_job exists in the