datapump: unable to attach to job to kill_job
Hi,
I started then stopped a expdp job, then the dump file for the stopped job got deleted off the filesystem.
Now, when I try to attach to it, I receive an error (see below). Since I cannot attach to the job, I cannot KILL_JOB it, and the job just sits in there in dba_datapump_jobs.
I would like to clean this job out. Does anyone know how I might do this?
Thank you in advance for any assistance,
dave
############################
Error:
Code:
$ expdp system/***** attach=BAD_JOB
Export: Release 10.2.0.1.0 - Production on Thursday, 01 March, 2007 18:28:18
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "/u02/exports/datapump_export_dir/dump-file-name.dmp" for read
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3