ORA-22922 Errors Can Occur With Patch For Bugs 8819768 And 13877007 Applied
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.3 to 22.214.171.124 [Release 10.2 to 11.2]
Information in this document applies to any platform.
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms