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 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 11-Apr-2013***

Goal

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

Solution

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