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';