ORA-39083 ORA-01405 While Doing Datapump Export/Import (Doc ID 1547470.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

When doing export/import using datapump following error is coming:

ORA-39083: Object type PROCDEPOBJ failed to create with error:
ORA-01405: fetched column value is NULL
Failing sql is:
BEGIN
SYS.DBMS_AQ_IMP_INTERNAL.IMPORT_QUEUE(HEXTORAW('756F6335D322AB1DE0404B0A25767393'),'DBL_FILE_RECEIPT_QTABLE','DBL_FILE_RECEIPT_QUEUE',0,5,0,0,0,'');COMMIT; END;


Processing object type SCHEMA_EXPORT/TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT
ORA-39083: Object type PROCDEPOBJ_GRANT failed to create with error:
ORA-01405: fetched column value is NULL
Failing sql is:
BEGIN
SYS.DBMS_AQADM.GRANT_QUEUE_PRIVILEGE('ENQUEUE','DBL_FILE_RECEIPT_QUEUE','DRUID_DATA_OWNER_FR33_PROD',FALSE);COMMIT; END;

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms