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

Thread: INDEX ERROR

  1. #1
    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




  2. #2
    Join Date
    Sep 2001
    Posts
    62
    I've got the ansewr guys, multiple of DB_BLOCKS

  3. #3
    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

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