Re: How can i change the MAXEXTENTS ??

Unfortunately you can not change the maxextents of a table

Only way to get rid of it is to take an export of that table and inport it back. Make sure to create initial extent to hold all of your current table data also make sure to define next_extent and pct_increase parameters which are responsible for the growth of the number of extents

EXE wrote in message <35D7D6A9.5EADACCC_at_exesolutions.com>...
>> Hi All, I got into the problem with the MAXEXTENTS of the table. It has
>> reached to its maxlevel of the 121/121. How can I increase it?? Has
anybody
>> know the syntex for it ? How it affects to performace? And what is the
>> recommanded number oof extents for a table??
>
>The best advice I can give you is DON'T. 121 extents means terrible
performance.
>In fact even though Oracle will now allow you to have billions of extents
the
>only thing this will do is make your system performance drop threw the
floor.
>
>Drop the table and recreate it with the correct sizing for the first
extent. If
>you have data that you don't want to back up then create a new table, move
the
>data, and then rename it.
>
>Regards,
>
>Daniel A. Morgan
>
Received on Tue Aug 18 1998 - 19:50:11 CDT