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

Thread: INDEX ERROR

  1. 10-26-2001, 12:08 PM #1
    sazzadur
    sazzadur is offline Junior Member
    Join Date
    Sep 2001
    Posts
    62
    Hi,

    I have recieved the following error:

    unable to extend index IFSAPP.PART_COST_BUCKET_4_IX by 31643 in tablespace
    IFSAPP_INDEX


    I think it's related to the maxextents on my tablepace beacuse the maxextens fro the index are ok. Can anyone tell me what 31643 represents. Is this KB,Bytes, blocks ?



    Thanks

    Shaz



    Reply With Quote Reply With Quote
  2. 10-26-2001, 12:20 PM #2
    sazzadur
    sazzadur is offline Junior Member
    Join Date
    Sep 2001
    Posts
    62
    I've got the ansewr guys, multiple of DB_BLOCKS
    Reply With Quote Reply With Quote
  3. 10-26-2001, 02:31 PM #3
    buffalodba
    buffalodba is offline Member
    Join Date
    Oct 2001
    Location
    Buffalo, NY
    Posts
    46
    Actually, I believe your problem is you've run outta physical space in your datafile(s) for your index tablespace. If the problem woulda been maxextents, you'da gotten a different error like 'maxextents reached on ...' Either add another datafile or resize a current one.
    Tim Hussar
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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