ORA-01456 When Exporting 10gr2 Grid Repository (Doc ID 372969.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Following errors when trying to export 10.2 Grid Repository

Export log with when exporting sysman schemas:

.. exporting table MGMT_CORRECTIVE_ACTION
EXP-00008: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-28112: failed to execute policy function



Trace file :

Policy function execution error:
Logon user : SYSTEM
Table/View : SYSMAN.MGMT_CORRECTIVE_ACTION
Policy name : EM_CA_POLICY
Policy function: SYSMAN.MGMT_USER.GET_CA_PREDICATE
ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction
ORA-06512: at "SYSMAN.MGMT_USER", line 8405
ORA-06512: at "SYSMAN.SETEMUSERCONTEXT", line 10
ORA-06512: at "SYSMAN.MGMT_USER", line 8121
ORA-06512: at line 1

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