Jmodic,

thanks for your reply, I did read the error and I tried to fix it once. The original MAXEXTENT was 505 and it bomb so I increase it to 1010 and it still bomb and I thought that there is a trick someone might to to fix this problem so that I posted it in here.

Any way, if I can not have my delete in smaller transaction so I have to increase the MAXEXTENTS but to what value ???