IMPDP、EXPDP进程CTRL+C后未终止

问题描述

数据泵窗口我CTRL+C后，进程一直还在跑，请问如果终止

专家解答

DATAPUMP进程是后台进程，前台CTRL+C是无法终止的，正确的终止方式是进到JOB中KILL_JOB：

首先找到刚才的job名称：

在之前导出或者导入的日志中会显示JOB名称，或者通过如下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;

再进入到job中stop_job、KILL_JOB

oracle@db1:/oracle$expdp \"/ as sysdba\" attach=SYS_EXPORT_TABLE_01

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>