Hi all
We have trouble about daily expdp batch error. Would you please help us?
Almost all time, expdp job ended successfully and another expdp at next day also ended successfully.
But, this expdp job ended successfully status but master table could not deleted.
So our expdp batch got following errors.
ORA-31626: job does not exist
ORA-31633: unable to create master table "spedified table name"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1038
ORA-00955: name is already used by an existing object
When we got errors, we tried to get object_name.
SQL> select o.status,o.object_name from dba_objects o, dba_datapump_jobs j
2 where o.owner=j.owner_name and o.object_name=j.job_name and o.owner='my owner' ;
STATUS OBJECT_NAME
----------- ----------------------
VALID (expdp's JOB_NAME PARAMETER)
We have 2 questions.
1) Why job name or master table could not delete ?
When this situation occurred, the expdp job at next day ended with above errors.
2) Can we get normal end when expdp at the next day even get an error?
If we get error from expdp, we want to force execute expdp.
Best Regards,
Keiko