tag:blogger.com,1999:blog-18037024.post2835907412067241202..comments2024-02-16T14:33:11.277+01:00Comments on Annals of Oracle's Improbable Errors: ORA-22922: nonexistent LOB valueByte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-18037024.post-74765958082124467372013-04-26T15:27:31.104+02:002013-04-26T15:27:31.104+02:00My guess is that since you are committing the lob ...My guess is that since you are committing the lob asynchronously, sometimes it works because it finishes quickly, sometimes doesn't.<br /><br />It could be thatthe async feature is not "fit" for this specific case.<br /><br />Just my 50 cents.Byte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-82941038145761786112013-04-25T14:26:04.948+02:002013-04-25T14:26:04.948+02:00
I am getting this error sporadically. The same tr...<br />I am getting this error sporadically. The same transaction works fine if I retry. Below is my table definition.<br />lob(DOC_DATA) store as securefile LS__DD1<br />(<br />tablespace DBLOB disable storage in row chunk 16k retention auto nocache logging<br />storage(maxextents unlimited pctincrease 0 freelists 12 freelist groups 2)<br />index LI__DD1 (tablespace DBLOB storage(maxextents Mukundhttps://www.blogger.com/profile/11127349779246964158noreply@blogger.com