Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01691: unable to extend lob segment

RPuttaguntaSep 21 2006 — edited Jun 24 2009

Hi,

I was running an XML transformation using dbms_xmldom package and when I do this for a 1.65 MB sized XML ( the XML is a NON SCHEMA BASED column in a table).

I got this error:

ORA-1691: unable to extend lobsegment XXXXXXX.SYS_LOB0000073404C00015$$ by 1024 in tablespace XXXXX

I would think that I am getting this error because I have built the table by default parameters. Just a create statement. Need some help in tweaking with the parameters while creating the table and the tablespace too.

I would be happy to send the parameters I used for this if you say they are relevant here. Please let me know what exactly would you want me to provide. I also have a trace file when I ran that procedure.

Thank you,
Rahul.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2009

Added on Sep 21 2006

#performance-availability, #xml-db

15 comments

190,432 views