My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.