Search This Blog

To kill Import/export Process in Oracle Database

In Import or Export command there is a parameter to provide job name using JOB_NAME . 


Command to find the job name for import/export

SQL> select * from dba_datapump_jobs


To kill the job of impdp/expdp

Press Ctrl+c once 

This will show the following :

import>

where u have to eneter "kill_job"

import> kill_job
Are you sure you wish to stop this job (y/n): y

you just killed the import job
which is also being removed from  dba_datapump_jobs


Launch your Online Business with a $5.99 .COM!