Stop the EXPDP/IMPDP Datapump Job in Oracle

Stop or terminate the EXPDP / IMPDP datapump job in Oracle

Expdp / Impdp utility is used to take the logical backup of the oracle database.

Note : By stopping the session with CTRL+C or close the window the expdp/impdp is not stopped. It performed it activity in background. For stop the datapump job you need to check the dba_Data

For stopping or killing the oracle datapump job you need to perform the following steps:

1. Check the job status from database login.

select * from dba_datapump_jobs;

OWNER_NAME JOB_NAME             OPERATION JOB_MODE STATE     DEGREE ATTACHED_SESSIONS
---------- -------------------- --------- -------- --------  ------
-----------------
SYSTEM     SYS_EXPORT_SCHEMA_01 EXPORT    SCHEMA   EXECUTING  1    
1

2. Get the job name from the output.

SYS_EXPORT_SCHEMA_01

3. Attached the job with following parameter.

expdp system/manager attach=SYS_EXPORT_FULL_01

 
4. Check the status of the job.

expdp status

5. Stop or kill the job running.

Export> KILL_JOB
Are you sure you wish to stop this job ([yes]/no): yes
$>

6. Check the status from dba_datapump_jobs.

select * from dba_datapump_jobs

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.