expdp system/oracle directory=mydata dumpfile=wlh.dmp logfile=wlh.log full=y

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

SQL> select job_name,state from dba_datapump_jobs;

JOB_NAME STATE

------------------------------ ------------------------------

SYS_EXPORT_FULL_01 EXECUTING

SYS_IMPORT_FULL_01 NOT RUNNING

expdp \'/ as sysdba\' attach=SYS_EXPORT_FULL_01

暂停

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

ITPub博客

oracle expdp后台终止或者暂停