Re: Changing MAX EXTENTS on an object?

Hi sean,

ALTER TABLE <tablename>
<storage-clause>;

Remember that maximum number of extends is OS-specific(NT and v7.3 121). See you OS-related docs for details.

Sean Kubovcik wrote:
>
> I have several (200) tables and indexes that have their MAX EXTENTS =
> 10. I want to change all of these to 249. What would be the most
> efficient way to do this? Any input would be appreciated.
>
> Thanks in advance,
> Sean
 

-- 
Regards

Matthias Gresz    :-)