清除expdp作业

执行了一个expdp,中途出错停止运行,但检查下面的数据字典,发现还有这个作业的信息,怎么处理?

 

SQL> select JOB_NAME,OWNER_NAME,STATE from dba_datapump_jobs;

JOB_NAME        OWNER_NAME                     STATE
--------------- ------------------------------ ------------------------------
DYXTE11T        SYSTEM                         NOT RUNNING

 

用如下办法停

 

SQL>conn system/******

Connected.

 

SQL> drop table DYXTE11T;

Table dropped.

 

再查看dba_datapump_jobs,没有了

 

SQL> select JOB_NAME,OWNER_NAME,STATE from dba_datapump_jobs;

no rows selected

---完----