请问:
如果我在执行EXPDP 出错了,这个时候我又把原来的生成的文件删除了.那么这个出错的EXPDP 将一直记录在DBA_DATADUMP_JOBS中.例如
SQL> SELECT * FROM DBA_DATAPUMP_JOBS
2 /
OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------ ---------- ----------------- -----------------
SYS SYS_EXPORT_FULL_01 EXPORT FULL NOT RUNNING 0 0 0
NQPIS BIN$rQ2wnNS7SgyekrR+ea+0Aw==$0 EXPORT FULL NOT RUNNING 0 0 0
SYS SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA NOT RUNNING 0 0 0
NQPIS BIN$KGANVxEVS8K+Sp4TwDU8UA==$0 EXPORT TABLE NOT RUNNING 0 0 0
并且无法结束这些任务,请问如何做能把这些任务结束啊.
我把对应的SCHEMA下生成的主表干掉后就还是没有把这些任务删除,只是JOB_NAME 变成了BIN$KGANVxEVS8K+Sp4TwDU8UA==$0 ....
请问如何解决啊?