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