Re: Not able to insert rows becoze of extent size
calyanram@hotmail.com wrote:
> I am not able to add rows even though space is available in dbspace.
>
>
> how to alter the extent size of the table?
>
> shall i need to reorg or is there any way to do?
>
> regards
> s.kalyan
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
>
On IDS 7.3x I first reorg tables. for example:
alter fragment on table messages INIT IN datadbs;(chek free space before !!!!)
and after that:
alter table messages MODIFY NEXT SIZE 48000;
Dimitar;