微信公众号：爱问CTO
专业编程问答社区
www.askcto.com
数据泵窗口CTRL+C后，进程一直还在。dmp文件还在增加。DATAPUMP进程是后台进程，前台CTRL+C是无法终止。
1.通过sql查找查询出job_name
SELECT owner_name, job_name, operation, job_mode, state, attached_sessions
FROM dba_datapump_jobs
WHERE job_name NOT LIKE 'BIN$%'
ORDER BY 1,2;2.正确停止expdp导出任务使用stop_job
[oracle@database ~]$ expdp \"userName/pwd@orcl" attach=SYS_EXPORT_SCHEMA_02
Export> stop_job
Are you sure you wish to stop this job ([yes]/no): yes
Export> KILL_JOB
Are you sure you wish to stop this job ([yes]/no): yes
Export>
**粗体** _斜体_ [链接](http://example.com) `代码` - 列表 > 引用。你还可以使用@来通知其他用户。