Failed Jobs can be verified by using the following sql:
sql > select owner_name,job_name,operation,job_mode,state,attached_sessions from dba_datapump_jobs;
Check the state (status ) of the Jobs all the failed Jobs,they will show as not running for failed once.
DROP MASTER TABLE
Since the above jobs are orphaned or not running won’t be restarted anymore, so drop the master table.
The master tables above are (SYS_EXPORT_FULL_01, SYS_EXPORT_FULL_02, SYS_EXPORT_FULL_01) .
SQL*Plus: Release 10.2.0.4.0 – Production on Fri Aug 23 10:14:16 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> drop table SYS_EXPORT_FULL_01;
Table dropped.
SQL> drop table SYS_EXPORT_FULL_02;
Table dropped.
Dropping these tables will have no impact on you new jobs are any database objects.
Now lets check if the Jobs are still showing with the failed status.
Home 