Insert into Table Followed by Commit Fails with ORA 7445 [kkzfjvfr_findrowids()+427] when Having MView With ORA_ROWSCN Datatype (Doc ID 1463789.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Getting below error while committing an insert statement on a master table that has an Mview with ORA_ROWSCN datatype.

ORA-07445: exception encountered: core dump [kkzfjvfr_findrowids()+427] [ACCESS_VIOLATION] [ADDR:0x6] [PC:0x325BA61] [UNABLE_TO_READ] []

Changes

 Creating mview with ORA_ROWSCN datatype causes insert into table to fail with ORA-07445 [kkzfjvfr_findrowids].

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