Oracle 终止expdp/impdp进程运行的方法

Oracle 终止expdp/impdp进程运行的方法

SELECT owner_name, job_name, operation, job_mode, state, attached_sessions
  FROM dba_datapump_jobs
 WHERE job_name NOT LIKE 'BIN$%' and owner_name like'HTNCC1909%'
 ORDER BY 1, 2

SELECT o.status,
       o.object_id,
       o.object_type,
       o.owner || '.' || object_name "OWNER.OBJECT"
  FROM dba_objects o, dba_datapump_jobs j
 WHERE o.owner = j.owner_name
   AND o.object_name = j.job_name
   AND j.job_name NOT LIKE 'BIN$%'  and j.owner_name like'HTNCC1909%'
 ORDER BY 4, 2;

drop table HTNCC1909_20220106.SYS_IMPORT_FULL_01;

例如

drop table HTNCC1909_20220106.SYS_IMPORT_FULL_01;