Oracle – RMAN – Clean datapump job

Posted by Ray Fox

SELECT 'drop table ' || owner_name || '.' || job_name || ';'
FROM dba_datapump_jobs WHERE state='NOT RUNNING' and attached_sessions=0;

exec the sql

dbafox