oracle正确停止导入导出或导入导出卡住的处理方法

查看数据库中所有数据泵操作：

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

通过 SQL*Plus 找到相关的 master 表：

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$%' ORDER BY 4,2;

对于过去被终止的和根本不会再启动的作业，删除它的 master 表：

DROP TABLE V3XUSER_TEST.SYS_IMPORT_FULL_01;