Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011

    Unanswered: space allocation problem in user table.

    in ASE CE, the message coming as [1105] can't allocate space for 'BOOKING_JOURNAL', segment is full.

    But I have found that the 'BOOKING_JOURNAL' segment 'seg_bkj' lies in the 'default segment' and there is almost 1.2G space free.

    please help.

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    No, one segment can't lie in another segment.
    But more than one segment can be defined on a device (file)
    Have a look at
    sp_extendsegment segname, dbname, devname

  3. #3
    Join Date
    Apr 2011
    thanks for post.

    But I want to inform that Booking-Journal segment and default segment lies in the same device. And there was sufficient amount of space on that device. Then why that message come and all transaction to that table suspended.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts