记录一次无法删除job

1、由于数据库/opt目录满了。导出，导入进程异常终止，先用了drop方式杀了相关的drop。但是无法执行。报错如下：

2、使用一下语句查看job相关的信息

col owner_name for a20;
col owr for a8;
col  job_name for a20;
col  operation for a10;
col  job_mode for a10;
col state for a10;
col attached_session for a5;
select owner_name owr,job_name,operation,job_mode,state,degree,attached_sessions,datapump_sessions from dba_datapump_jobs;

3、通过v$session与v$dba_datadump_session的saddr相互关联，查出相关的sid serial#，然后杀掉。

select sid,serial#,session_type from v$session s, dba_datapump_sessions d where s.saddr=d.saddr;

然后kill掉两个master的session。就可以终止会话了。

还可以用过一下的视图，获得相应的job运行。

In interactive mode, you can get a lot of detail through the STATUS command. In SQL, you can query the following views:

 DBA_DATAPUMP_JOBS - all active Data Pump jobs and the state of each job
 USER_DATAPUMP_JOBS – summary of the user’s active Data Pump jobs
 DBA_DATAPUMP_SESSIONS – all active user sessions that are attached to a Data Pump job
 V$SESSION_LONGOPS – shows all progress on each active Data Pump job