Stop 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 )

w

Connecting to %s

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