Unable to extend LobSegment
I've a big problem. i took a error message from the alert log as below.
We have been using oracle application 11i and oracle 9i for database.
There is enough space in the APPLSYSD table space.
How do i do?, could you help me urgently
ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000033586C00004$$ by 92170 in tablespace APPLSYSD
Try to coalesce the tablespace. It could be that the extent that is being allocated is larger that the largest free extent. You may want to look at pctincrease on the tables in that tablespace and make sure that it is set to 0. Are you using locally managed tablespaces? If so are you using uniform extent size or do you let Oracle size the extents?
this space intentionally left blank
I solved lobsegmet problem, i extended my table space enough, approximately 1000 mb
Thank you for your helps
Click Here to Expand Forum to Full Width