ORA-22922 Errors Can Occur With Patch For Bugs 8819768 And 13877007 Applied (Doc ID 1552147.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

While inserting into a LOB column of a partitioned table, an error

can occur, if a concurrent DDL (e.g TRUNCATE) on another partition is in progress at the same time.

Changes

Patches for <Bug 8819768> and <Bug 13877007> are in place.

The latter bug fixes an ORA-600 [kokegPinLob1] during an INSERT, introduced by the changes made to fix <Bug 8819768>.
When the patch for <Bug 13877007> is in place, ORA-600 [kokegPinLob1] during an INSERT no longer occurs, but an ORA-22922 'Nonexistant LOB value' can occur.

Please refer to:
<Note 8819768.8> - Bug 8819768 - Temp tablespace space leak / ORA-1652 from DML on LOB with a trigger - superseded
<Note 13877007.8> - Bug 13877007 - ORA-600 [kokegPinLob1] during INSERT to partitioned table with LOB data

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