Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: max extents....

Re: max extents....

From: <satar_at_my-dejanews.com>
Date: 1998/10/20
Message-ID: <70ivu0$fd9$1@nnrp1.dejanews.com>#1/1

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 Tue Oct 20 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US