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博客