It never fails, every time I have a quick request that I should be able to hammer out in a few minutes something hampers it. Today is just one of those days. I needed to perform an expdp/impdp on a small schema between development and testing and I received an error:
ORA-31634 Unable To Construct Unique Job Name By Default
I generally always default the job name on data pumps exports especially if they are one offs. However, today this just didn’t cooperate. Apparently we have experienced some failures with other exports running and the tables still exist. There’s a limit of 99. An easy check:
select owner_name,state,job_name from dba_datapump_jobs;
If the number of records returned equal 99 then simple delete the tables. SYS_EXPORT_SCHEMASxx; — replacing the xx with the number displayed in the output from above.
Restart the export.