My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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


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

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