Unable to extend LobSegment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Unable to extend LobSegment

  1. #1
    Join Date
    Dec 2006
    Posts
    2

    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
    Location
    Pittsburgh, PA
    Posts
    4,026
    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
    Posts
    2
    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