Cleanup orphaned datapump jobs from DBA_DATAPUMP_JOBS In many cases you sometimes stop data pump job or in case of an abnormal end of the Data Pump job (we call it the orphaned job) or using undocumented parameter KEEP_MASTER=Y, the master table remain in the database. It is good to know several things before doing cleanup jobs. 1) You can check the orphaned data pump from the STATE COLUMN of the view dba_datapump_jobs. And DBA_DATAPUMP_JOBS is based on gv$datapump_job, obj$, com$, and user$. Orphaned Data Pump jobs do not have an impact on new Data Pump jobs. If a new Data Pump job is started, a new entry will be created, which has no relation to the old Data Pump jobs. 2) For a new data pump job without any job name it is used a system generated name. From the dba_datapump_jobs it is checked for existing data pump jobs and then obtain a unique new system generated jobname. 3) If you drop the master table while doing the data pump export or data pump import operation the...