Database Utilities (MOSC)

MOSC Banner

How to find out which data pump jobs are safe to remove

edited Jan 28, 2014 4:00AM in Database Utilities (MOSC) 10 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center