ORA-31693 And ORA-01031 When Creating Full Database Export on Oracle12c With Externally Defined User

(Doc ID 1676376.1)

Last updated on JULY 01, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When trying to create a full database export from an Oracle12c database using an externally defined used, the following errors are raised:

Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
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

ORA-31693: Table data object "SYS"."FGA_LOG$FOR_EXPORT" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges


An example:

sqlplus / as sysdba
SQL> create user ops$testora identified externally;
SQL> grant connect to ops$testora
SQL> grant read,write on directory DATA_PUMP_DIR to ops$testora;
SQL> grant create table to ops$testora;
SQL> grant datapump_exp_full_database to ops$testora;
SQL> grant exp_full_database to ops$testora;
SQL> grant flashback any table to ops$testora;
SQL> grant become user to ops$testora;
SQL> alter user ops$testora quota unlimited on users;


After having verified that the externally defined user can connect to the instance, start the export operation:

expdp / full=y flashback_time=systimestamp dumpfile=expdp.dmp logfile=expdp.log
...
Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
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
ORA-31693: Table data object "SYS"."DBA_SENSITIVE_DATA" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
ORA-31693: Table data object "SYS"."DBA_TSDP_POLICY_PROTECTION" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
...
ORA-31693: Table data object "SYS"."NACL$_HOST_EXP" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
ORA-31693: Table data object "SYS"."NACL$_NAME_MAP_EXP" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
ORA-31693: Table data object "SYS"."NACL$_WALLET_EXP" failed to load/unload and is being skipped due to error:
ORA-01031: insufficient privileges
...

Changes

A migration to Oracle12c took place.

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