My Oracle Support Banner

EXPDP - ORA-1031 On Full Database Export Of Data Vault Database (Doc ID 1571062.1)

Last updated on APRIL 03, 2020

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.

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data .Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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

 

Changes

 NONE

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.