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