Xref: alice comp.databases.oracle.server:74725
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!not-for-mail
From: andreyNSPAM@bookexchange.net (NetComrade)
Newsgroups: comp.databases.oracle.server
Subject: Re: hit max extents on table
Date: Thu, 18 Nov 1999 20:36:24 GMT
X-ELN-Insert-Date: Thu Nov 18 12:45:24 1999
References: <01bf304f$590df5e0$42b415a5@ddd> <80sf4i$8u2$1@front5m.grolier.fr> <01bf310a$d7018be0$4fb415a5@ddd>
X-Newsreader: Forte Free Agent 1.11/32.235
Organization: EarthLink Network, Inc.
X-Posted-Path-Was: not-for-mail
Lines: 21
X-ELN-Date: 18 Nov 1999 20:40:39 GMT
Message-ID: <3834633d.853737@news.earthlink.net>

Yes
On 17 Nov 1999 14:51:10 GMT, "abc" <oldman@hotmail.com> wrote:

>thanks. but I would not want unlimited extents. can i specify some values
>like 300 for example.. ?
>
>
>Guang Ju YANG <yangg@club-internet.fr> wrote in article
><80sf4i$8u2$1@front5m.grolier.fr>...
>> from version 7.2.3 on, you could issue :
>>     alter table xxx storage (max_extents unlimited).
>> but this decrease dramatically the performance.
>> you should reorganize the table in order to keep a low level extents for
>a
>> table.
>> 
>

---------------
Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email