killing export/import job that is running

Ø  how to kill export/import when running on the screen.

press ctrl+C and 

Import> KILL_JOB ---and at prompt hit 'yes'

sqlplus / as sysdba

SQL> select job_name,state from dba_datapump_jobs;

if you see any table.... make sure that it is you who started...then drop it...

Ø   If the job is running in the background.... how to kill it.

> grep for import/export job at unix and kill that process..'kill -9 osid'

kill at unix will not kill the export/import job.

sqlplus / as sysdba

SQL> select job_name,state from dba_datapump_jobs;

if you see any table.... make sure you see executing/or stopped...

evoke the import/job and atatch the job that was kicked off...

impdp/expdp system/xxxx attach=sys_import_schema_01
>Import/Export> KILL_JOB -- and at prompt hit yes.

drop the table that got from above if it still exists.

Hope this helps.....