ORA-1691, yet a few bytes are written in the LOB of the table
Date: Mon, 8 Jun 2009 03:28:12 -0700 (PDT)
Message-ID: <22489b8e-1ec1-449d-b9e9-0cc4dd87817c_at_j18g2000yql.googlegroups.com>
Hi,
For a little more than 24 hours we've been having
- "ORA-1691: unable to extend lobsegment XX by 64 intablespace
-
<lob tbsp>..."
in our alert log file (tablespace autoextend clause has been
modified now), but we noticed that in this table the insert
statements that took place after the error started appearing worked
and even that data was partly created in its only LOB column: it
succeeded for a few bytes only (we store PDF files: we can open
them and see the first few lines of every document made since
yesterday)...
We are in 10g R2, and the table is defined with a LOB column that has its own tablespace (where we had this problem).
How come Oracle wrote a few bytes each time and then failed with "ORA-1691: unable to extend lobsegment ..." and commited the record insert ??
Thanks.
Seb
Received on Mon Jun 08 2009 - 05:28:12 CDT