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
Smart way of Technology 