ORA-07445 [0000F414] Error And Lot Of Trace Files Generated When Mview Refreshing
Last updated on MARCH 27, 2014
Applies to:Oracle Server - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Sep-2012***
-- Problem Statement:
On 10.2.0.4 in Production:
When a materialized view is refreshed, the following error occurs:
ORA-07445: exception encountered: core dump [0000F414] [SIGSEGV] [Invalid permissions for mapped object]
-- Steps To Reproduce:
The issue can be reproduced at will when the refresh is made or when the insert found in the trace file is executed from sqlplus.
Trying to execute the same insert in a test table same structure as the materialized view could not reproduce the error.
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