Re: max extents....

So is the answer here that you can set extents to max out anywhere you want, but it's actually limited by the db_block size? (121,249,505 etc.,)

• Dc.

satar_at_my-dejanews.com wrote:

> Actually in your version of Oracle, you can have UNLIMITED extents. However,
> it is limited by the size of your hard drive.
>
> ALTER TABLE "AMGTEST"."BLDG" STORAGE ( MAXEXTENTS UNLIMITED);
>
> Satar
>
> In article <362B8D30.436671B0_at_enterprise.net>,
> Tony Commander <acommander_at_enterprise.net> wrote:
> > I'm sure I've read somewhere that the limit to a number of extents in
> > tables/indexes
> > has been raised/removed in a recent version of oracle ( we're running
> > 7.3.4 on NT 4 )
> > from the old limit of 249.
> >
> > Is this my imagination or did I really read this somewhere a while ago?
> >
> >
>
> --
> Oracle DBA/UNIX System Admin
> Advanced Enterprise Solutions
> (949) 756-0588
> Oracle Re-Seller
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 29 1998 - 10:39:32 CST