ORA-07445 [0000F414] Error And Lot Of Trace Files Generated When Mview Refreshing (Doc ID 951943.1)

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***


Symptoms

-- Problem Statement:
On 10.2.0.4 in Production:
When a materialized view is refreshed, the following error occurs:

ERROR
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.

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