Full Database Export Fails With Errors ORA-1031 EXP-83 On Resource Manager Objects (Doc ID 105955.1)

Last updated on MAY 13, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.0 and later
Information in this document applies to any platform.
***Checked for relevance on 13-May-2013***

Symptoms

Full database export performed by a non-SYS/SYSTEM user when connected as a user with EXP_FULL_DATABASE role generates the following errors:

..exporting roles
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RMGR_PLAN_EXPORT", line 216
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling
SYS.DBMS_RMGR_PLAN_EXPORT.grant_sysprivs_exp
....
. exporting system procedural objects and actions
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_ZHELP_IR", line 0
ORA-06512: at "SYS.DBMS_RMGR_PACT_EXPORT", line 62
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling
SYS.DBMS_RMGR_PACT_EXPORT.system_info_exp
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RMGR_PLAN_EXPORT", line 163
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_RMGR_PLAN_EXPORT.drop_exp for object 2553
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RMGR_GROUP_EXPORT", line 205
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_RMGR_GROUP_EXPORT.drop_exp for object 2555
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RMGR_GROUP_EXPORT", line 205
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_RMGR_GROUP_EXPORT.drop_exp for object 2557
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RMGR_GROUP_EXPORT", line 205
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_RMGR_GROUP_EXPORT.drop_exp for object 2556
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RMGR_GROUP_EXPORT", line 205
ORA-06512: at line 1
EXP-00085: The previous problem occurred when calling
SYS.DBMS_RMGR_GROUP_EXPORT.drop_exp for object 2554
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_ZHELP_IR", line 0
ORA-06512: at "SYS.DBMS_RMGR_PACT_EXPORT", line 62
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling
SYS.DBMS_RMGR_PACT_EXPORT.system_info_exp
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
...

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