DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006

    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

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    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

  3. #3
    Join Date
    Dec 2006
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.