Re: Help max extends

From: Mark D Powell <mark.powell_at_eds.com>
Date: 13 Mar 2002 08:07:31 -0800
Message-ID: <178d2795.0203130807.36418a8b@posting.google.com>

"Sylvain GRAVERON" <sylvain.graveron_at_rlf-rj.com.fr> wrote in message news:<a6n86d$m01$1_at_reader1.imaginet.fr>...
> hello
> How to modify in a table on contraints max extends fixe to 99 (ex auto
> extends)
>
> Tks
> Sylvain

If I understand your question see the SQL manual for alter table: alter table owner.table_name storage (maxextents nn);

If your system is Oracle 8.1+ you should consider rebuilding/modifying your database to use locally managed tablespaces. For version 8.1 and lower with dictionary managed space allocation the maxextents parameter maximum value is dependent on the Oracle block size so whenever a table gets a larger number of extents you should consider if the extent size needs changing.

HTH -- Mark D Powell -- Received on Wed Mar 13 2002 - 10:07:31 CST