Data Pump Export Fails with ORA-31631 and ORA-39109 (Doc ID 1482248.1)

Last updated on AUGUST 08, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.

Symptoms

 Data Pump Export Fails with ORA-31631 and ORA-39109:


expdp userid=UHG_test/UHG_test DUMPFILE=expdp.dmp LOGFILE=expdp.log DIRECTORY=my_dir CONTENT=metadata_only SCHEMAS=SCOTT

Export: Release 10.2.0.5.0 - Production on Monday, 18 June, 2012 13:10:29

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31631: privileges are required
ORA-39109: Unprivileged users may not operate upon other users' schemas

 

 

Changes

 Privileges defined by the role EXP_FULL_DATABASE is granted individually, e.g:

 


GRANT CONNECT TO UHG_TEST;
GRANT SELECT_CATALOG_ROLE TO UHG_TEST;
ALTER USER UHG_TEST DEFAULT ROLE ALL;

...  
GRANT CONNECT TO UHG_TEST;
GRANT SELECT_CATALOG_ROLE TO UHG_TEST;
ALTER USER UHG_TEST DEFAULT ROLE ALL;
--grant EXP_FULL_DATABASE TO UHG_TEST;
ALTER USER UHG_TEST QUOTA 512M ON TOOLS;
...
GRANT RESUMABLE TO UHG_TEST;
GRANT BACKUP ANY TABLE TO UHG_TEST;
GRANT EXECUTE ANY TYPE TO UHG_TEST;
GRANT SELECT ANY TABLE TO UHG_TEST;
GRANT READ ANY FILE GROUP TO UHG_TEST;
GRANT SELECT ANY SEQUENCE TO UHG_TEST;
GRANT EXECUTE ANY PROCEDURE TO UHG_TEST;
BEGIN
SYS.DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE
(GRANTEE_NAME   => 'UHG_TEST',
 PRIVILEGE_NAME => 'ADMINISTER_RESOURCE_MANAGER',
 ADMIN_OPTION   => FALSE);
END;
/
GRANT EXECUTE_CATALOG_ROLE TO UHG_TEST;
GRANT SELECT_CATALOG_ROLE TO UHG_TEST;

 

 

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