Attach and de-attach the EXPDP/IMPDP DATAPUMP jobs

Share via:

Hello Everyone,

In this article , we will learn how to Attach and de-attach the expdp/impdp  datapump jobs.

EXPDP and IMPDP is used to take the logical backup of full database, tablespace ,schema,table and query level.

we can attach or deattach the datapump jobs using job names.

In the first step we will start full database expdp job using below parameters

How to check the status of Datapump job :

While expdp job running fine , we can check status of datapump job using below statement.

Now we can Pause our job by using CTRL+C, then it will prompt EXPORT>>

How to Stop a Datapump job :

We can stop  the datapump job using STOP_JOB  or STOP_JOB=immediate

If we stop a datapump job the status of the job is STOP PENDING –> STOPPING –> NOT RUNNING 


How to Attach a stopped Datapump job :

We can attach datapump stopped jobs using ATTACH parameter.

Once we give attach with user credentials , datapump will display all details regarding our job.

To start a job we can use a  parameter START_JOB

Once we start the job the status of the job will become IDLEING  –> EXECUTING

Thank you for giving your valuable time to read the above information.

Follow us on 
Facebook Page KTexperts
Linkedin Page : KT EXPERTS


Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Add Comment