Default: job currently in the user's schema, if there is only one
Attaches the client session to an existing export job and automatically places you in the interactive-command interface. Export displays a description of the job to which you are attached and also displays the Export prompt.
Syntax and Description
schema_name is optional. To specify a schema other than your own, you must have the
job_name is optional if only one export job is associated with your schema and the job is active. To attach to a stopped job, 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, Export displays a description of the job and then displays the Export 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. The only exception to this is if the job was initially started with the
ENCRYPTION=ENCRYPTED_COLUMNS_ONLY parameter. In that case, the encryption password is not needed when attaching to the job.
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 will fail.
Altering the master table in any way will lead to unpredictable results.
The following is an example of using the
ATTACH parameter. It assumes that the job,
hr.export_job, already exists.
> expdp hr ATTACH=hr.export_job