EXPDP - ORA-31693 ORA-01031 (Insufficient Privileges) On Some Tables When Exporting from 12cR1 (Doc ID 1676411.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Enterprise Manager for Oracle Database - Version 12.1.0.1.0 to 12.1.0.6.0 [Release 12.1]
Oracle Database - Personal Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

1. When performing a full database consistent export with Export Data Pump from a 12.1.0.1 source database, the following errors occur:

$ expdp tc/tc directory=my_dir dumpfile=expdp_f.dmp logfile=expdp_f.log reuse_dumpfiles=y full=y flashback_time=systimestamp

Export: Release 12.1.0.1.0 - Production on Tue May 27 10:25:38 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "TC"."SYS_EXPORT_FULL_01":  tc/******** directory=my_dir dumpfile=expdp_f.dmp logfile=expdp_f.log reuse_dumpfiles=y full=y flashback_time=systimestamp
Estimate in progress using BLOCKS method...
Processing object type
DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
...
ORA-31693: Table data object "SYS"."KU$_USER_MAPPING_VIEW" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
...

For this job, similar ORA-1031 (insufficient privileges) errors are reported for:

ORA-31693: Table data object "ORDDATA"."ORDDCM_DOCS" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "SYS"."FGA_LOG$FOR_EXPORT" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "SYSTEM"."SCHEDULER_JOB_ARGS" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "SYSTEM"."SCHEDULER_PROGRAM_ARGS" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "SYS"."AUDTAB$TBS$FOR_EXPORT" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "SYS"."DBA_SENSITIVE_DATA" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "SYS"."DBA_TSDP_POLICY_PROTECTION" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "SYS"."NACL$_ACE_EXP" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "SYS"."NACL$_HOST_EXP" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "SYS"."NACL$_WALLET_EXP" failed to load/unload and is being skipped due to error:
ORA-31693: Table data object "WMSYS"."WM$EXP_MAP" failed to load/unload and is being skipped due to error:

2. The problem reproduces when the full database export DataPump job is done with FLASHBACK_TIME as well as with FLASHBACK_SCN.

3. The problem also reproduces if the following privileges are granted to the schema that runs the Export Data Pump job:

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