My Oracle Support Banner

ORA-7445 [Kgwsfin] on Update of Table With Deferrable Constraint (Doc ID 956702.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: and later   [Release: 10.2 and later ]
Information in this document applies to any platform.


A combination of INSERT and UPDATE on a table with deferrable constraint enabled, results in:

ORA-07445: [kgwsfin()+192] [SIGSEGV] [Address not mapped to object] [0x100000004] [] []

with call stack similar to:

kgwsfin, kxcbexi, kauupd, updrow, qerupRowProcedure, qerupFetch, updaul


The problem occurs at INSERT followed by an UPDATE on a table, after adding a constraint with 'DEFERRABLE INITIALLY DEFERRED USING INDEX'.

Use dictionary view ALL/DBA/USER_CONSTRAINTS, column DEFERRABLE to check if constraint is deferrable or not.


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

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