My Oracle Support Banner

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

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.