How to find out which data pump jobs are safe to remove
I was running data pump full export and gotten an error:
ORA-31634: job already exists
ORA-31664: unable to construct unique job name when defaulted
I cheked the table dba_datapump_jobs and it has 99 jobs in there, so that's why my export is failing. I need to cleanup orphaned datapump jobs as per document: