Attaching and Detaching a datapump Job

Attaching and Detaching a datapump Job

you can deattach or reattch datapump job.

1.) Get the Job name 

desc dba_datapump_jobs

Jetstar_SYS@traxmp > select owner_name,Job_name,state from dba_datapump_jobs

OWNER_NAME                     JOB_NAME                       STATE

------------------------------ ------------------------------ ------------------------------

SYSTEM                         SYS_EXPORT_SCHEMA_09           EXECUTING

SYSTEM                         SYS_EXPORT_SCHEMA_10           EXECUTING

SYSTEM                         SYS_EXPORT_SCHEMA_08           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_05           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_03           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_01           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_07           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_04           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_02           NOT RUNNING

SYSTEM                         SYS_EXPORT_SCHEMA_06           NOT RUNNING

2.) Attach the job using attach option 

expdp system/carrier attach=SYS_EXPORT_SCHEMA_09 

3.) We can check status,Kill job and resume it.

> staus

> KILL_JOB