I have recieved the following error:
unable to extend index IFSAPP.PART_COST_BUCKET_4_IX by 31643 in tablespace
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 ?
I've got the ansewr guys, multiple of DB_BLOCKS
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.
Click Here to Expand Forum to Full Width