oracle停止一切进程,oracle中expdp/impdp进程如何停止

微信公众号：51码农网

专业编程问答社区

www.51manong.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>