数据泵JOB

desc dba_datapump_jobs;
select job_name, state from dba_datapump_jobs;

Drop掉状态为NOT RUNNING的备份任务。

SELECT owner_name, job_name, operation, job_mode, state, attached_sessions FROM dba_datapump_jobs ORDER BY 1,2;
select 'drop table ' || owner_name || '.' || job_name || ';' from dba_datapump_jobs where state = 'NOT RUNNING';

expdp system/oracle attach=

Export> status

Export> kill_job
stop_job只是暂停，之后可以用start_job重新启动，而kill_job直接杀掉，不可恢复