oracle expdp后台终止或者暂停

1.先导出
expdp system/oracle directory=mydata dumpfile=wlh.dmp logfile=wlh.log full=y

Ctrl+c 掐断导出，发现并未真正断开expdp

2.查看会发现正在执行
SQL> select job_name,state from dba_datapump_jobs;
JOB_NAME STATE

SYS_EXPORT_FULL_01 EXECUTING
SYS_IMPORT_FULL_01 NOT RUNNING

3.进入这个后台
expdp ‘/ as sysdba’ attach=SYS_EXPORT_FULL_01

4.操作
暂停
Export>stop_job=immediate
Are you sure you wish to stop this job ([yes]/no): yes

删除
Export>kill_job （会顺便删除dmp文件的）

这句也可以删除
SQL>drop table system.SYS_EXPORT_FULL_02 purge;

拼接好的删除语句

select 'drop table ’ || owner_name || ‘.’ || job_name || ‘;’ from dba_datapump_jobs where state = ‘NOT RUNNING’;

select 'drop table ’ || owner_name || ‘.’ || job_name || ‘;’ from dba_datapump_jobs where state = ‘EXECUTING’;
                        
原文链接：oracle expdp后台终止或者暂停_expdp暂停会如何-CSDN博客