-
Unable to extend LobSegment
Hi everybody
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?
-
I solved lobsegmet problem, i extended my table space enough, approximately 1000 mb
Thank you for your helps
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|