DataPump Export (EXPDP) Fails With Error ORA-39826

SYMPTOM

06-JUN-18 09:27:43.735: ORA-31693: Table data object "XXX"."LOC_PK_ID" failed to load/unload and is being skipped due to error:

06-JUN-18 09:27:43.735: ORA-31693: Table data object "XXX"."LOC_PK_ID" failed to load/unload and is being skipped due to error:
x

ORA-02354: error in exporting/importing data

ORA-39826: Direct path load of view or synonym (XXX.LOC_PK_ID) could not be resolved.

06-JUN-18 09:27:43.742: ORA-31693: Table data object "XXX"."PL_PK_ID" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-39826: Direct path load of view or synonym (XXX.PL_PK_ID) could not be resolved.
 

CAUSE

Export backup has completed and backup was validated.  The below error was because of table was dropped during the run-time of EXPDP export that’s why doesn't find the table at the time of exporting that table.


 

SOLUTION

 

Please check whether the objects reported in the error message exist or not. The example below is related to the object mentioned in above error message:

SELECT OWNER, OBJECT_NAME, OBJECT_TYPE, STAUS, LAST_DDL_TIME

FROM   DBA_OBJECTS

WHERE  OWNER = 'XXX' AND OBJECT_NAME IN ('LOC_PK_ID');

no row selected
 

If the query returns no rows, then you can expect the ORA-39826 is raised. You should make sure that the object exists when it is exported and it is not removed during the runtime of export. Dropping an object during the master control table of DataPump export is created and filled but before the actual table contents are exported, will result in these type of error.