EXP-23 or IMP-13 When Performimg Full Export or Import (Doc ID 949279.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2
This problem can occur on any platform.

Symptoms

You created a user (USR001) and granted the roles EXP_FULL_DATABASE and IMP_FULL_DATABASE. This user is needed to perform full database exports/imports. When a full database export is started, this ends with error:

EXP-00023: must be a DBA to do Full Database or Tablespace export

A full database import ends with errors:

IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

You verified the privileges and the granted roles are there:

SQL> select * from dba_sys_privs where grantee = 'USR001';

GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
USR001                         CREATE SESSION                           NO

SQL> select * from dba_role_privs where grantee = 'USR001';

GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
USR001                         EXP_FULL_DATABASE              NO  NO
USR001                         IMP_FULL_DATABASE              NO  NO

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