oracle中expdp/impdp进程如何停止
文章目录

微信公众号:爱问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>

评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论