Re: Changing MAX EXTENTS on an object?

From what I came across as a dba so far, I have learnt that MAX EXTENTS is dependent on the database's DB_BLOCK_SIZE. So if had a DB_BLOCK_SIZE of 2048 then your MAXEXTENTS could be as much as 121 whereas
if you had a DB_BLOCK_SIZE of 4096 then your MAXEXTENTS could be as much as 249.

The command you use to alter maxextents is alter table TABLE_NAME storage(maxextents 249); Hope this helps!

Oracle DBA/Support
Vinay Joshi
Pinnacle Insurance Plc

> -----Original Message-----
> From: GreMa_at_t-online.de (Matthias Gresz) [SMTP:GreMa_at_t-online.de]
> Posted At: 27 January 1998 07:24
> Posted To: server
> Conversation: Changing MAX EXTENTS on an object?
> Subject: 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 :-)
Received on Tue Jan 27 1998 - 00:00:00 CST