Partial Index On Foreign Key Index Leads To Entire Child Table Being Locked When Update In Parent Table Is Performed
(Doc ID 3013634.1)
Last updated on APRIL 09, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterInformation in this document applies to any platform.
Symptoms
You are experiencing a full lock for child table as a result of records in parent table being updated when foreign key index is defined as partial index.
Changes
You have defined an index for a foreign key as a partial index.
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 |
| Changes |
| Cause |
| Solution |
| References |