What are the EXPORT/IMPORT FULL DATABASE System Priviliges?

(Doc ID 737614.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 11-Apr-2013***


You try to perform a full database export/import. For this reason, you granted the system privileges EXPORT(IMPORT) FULL DATABASE to the user but the export/import fail with error message, like demonstrated in the following example:

connect / as sysdba
drop user test_exp cascade;

create user test_exp identified by passwd default tablespace users temporary tablespace temp;
grant connect, resource, export full database to test_exp;

select * from dba_sys_privs where grantee = 'TEST_EXP';


GRANTEE                        PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
TEST_EXP                       EXPORT FULL DATABASE                     NO
TEST_EXP                       UNLIMITED TABLESPACE                     NO


select * from dba_role_privs where grantee = 'TEST_EXP';


GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
TEST_EXP                       CONNECT                        NO  YES
TEST_EXP                       RESOURCE                       NO  YES

Then, original export:

#>  exp test_exp/passwd file=test-exp.dmp full=y log=test_exp.log

stops with:

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

In similar way, DataPump export:

#> expdp test_exp/passwd directory=dpu dumpfile=test_exp.dmp full=y logfile=test_exp.log

stops with:

ORA-31631: privileges are required
ORA-39161: Full database jobs require privileges


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