EXPDP - ORA-1031 On Full Database Export Of Data Vault Database

(Doc ID 1571062.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When attempting to run a full database export from a Data Vault enabled database, the following error occurs.

% expdp \"/ AS SYSDBA\" DIRECTORY=my_dir DUMPFILE=expdp_f.dmp LOGFILE=expdp_f.log FULL=y

...
Starting "SYS"."EXPORT_FULL_JOB1":  /******** AS SYSDBA DIRECTORY=my_dir DUMPFILE=expdp_f.dmp LOGFILE=expdp_f.log FULL=y
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
...
Total estimation using BLOCKS method: 10.71 GB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [TABLE_DATA:"SCOTT"."MY_TAB"]
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8164
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x1c6a49ba8     19028  package body SYS.KUPW$WORKER
0x1c6a49ba8      8191  package body SYS.KUPW$WORKER
0x1c6a49ba8      2814  package body SYS.KUPW$WORKER
0x1c6a49ba8      8846  package body SYS.KUPW$WORKER
0x1c6a49ba8      1651  package body SYS.KUPW$WORKER
0x1cb2dc550         2  anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA []
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8159
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x1c6a49ba8     19028  package body SYS.KUPW$WORKER
0x1c6a49ba8      8191  package body SYS.KUPW$WORKER
0x1c6a49ba8      2814  package body SYS.KUPW$WORKER
0x1c6a49ba8      8846  package body SYS.KUPW$WORKER
0x1c6a49ba8      1651  package body SYS.KUPW$WORKER
0x1cb2dc550         2  anonymous block
Job "SYS"."EXPORT_FULL_JOB1" stopped due to fatal error at 11:34:21

 

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