how to kill/stop a datapump exp job after exit datapump in command line
592815Feb 4 2010 — edited Feb 4 2010Hi Experts,,
I made a exdpd RAC DB full export in window single DB by network_link.
Based on RAC instance undotbs issue, the export stop. I just exit.
However, I findexp session is still running as
SQL> select *from dba_datapump_jobs;
OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
---------- -------------------------------------------- ----------- ---------- ----------------- -----------------
SALE SYS_EXPORT_FULL_01 EXPORT FULL EXECUTING 1 0 2
SALE SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA NOT RUNNING 0 0 0
SYSTEM SYS_EXPORT_FULL_01 EXPORT FULL NOT RUNNING 0 0 0
How to kill DATAPUMP_SESSIONS 2 exp job?
Thanks
I am waiting for help!
JIm