How to kill jobs in "select * from DBA_DATAPUMP_JOBS"
Date: Fri, 5 Sep 2008 09:43:33 -0700 (PDT)
I am trying to kill the jobs that I see on DBA_DATAPUMP_JOBS (Oracle 10g R1)
select * from DBA_DATAPUMP_JOBS
OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS
SYS PHR_EXPORT2 EXPORT TABLE NOT RUNNING 0 0 SYS PHR_EXPORT EXPORT TABLE NOT RUNNING 0 0 SYS PHR_EXPORT1 EXPORT TABLE NOT RUNNING 0 0
I made those one connected as sys user.
Now, I can't kill them.
I try to get the prompt Export>kill_job, but I'm not able.
c:\expdp sys/passwordOfSys_at_servicename attach=PHR_EXPORT
Oracle asks me Username:, and I put system. After that:
Connected to: Oracle Database 10g Release 10.1.0.4.0 - Production
ORA-31626: job does not exist ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.KUPV$FT", line 330 ORA-31638: cannot attach to job PHR_EXPORT for user SYSTEM ORA-31632: master table "SYSTEM.PHR_EXPORT" not found, invalid, orinaccessible
ORA-00942: table or view does not exist
Is it any way to kill or delete the jobs showed in DBA_DATAPUMP_JOBS?
Thanks ! Received on Fri Sep 05 2008 - 11:43:33 CDT