Re: hit max extents on table

ALSO you might reconsider the NEXT <size>, so that your table doesn't overgrow again.
You can also Imp/Exp the table with compress=y, but if you have ingegrity constraints it's a small pain.

On Tue, 16 Nov 1999 17:59:38 +0100, "Michel Cadot" <micadot_at_netcourrier.com> wrote:

>alter table <your table> storage (maxextents <new limit or unlimited>);
>
>--
>Have a nice day
>Michel
>
>
>abc <oldman_at_hotmail.com> a écrit dans le message :
>01bf304f$590df5e0$42b415a5_at_ddd...
>> hi,
>> anyone can help on what i should do when I hit this max extentd on table.
>> can i increase the extents and is that a formula/command for it ?
>>
>> thanks.
>
>

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email