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: hit max extents on table

Re: hit max extents on table

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 18 Nov 1999 20:36:24 GMT
Message-ID: <3834633d.853737@news.earthlink.net>


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

>thanks. but I would not want unlimited extents. can i specify some values
>like 300 for example.. ?
>
>
>Guang Ju YANG <yangg_at_club-internet.fr> wrote in article
><80sf4i$8u2$1_at_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

Received on Thu Nov 18 1999 - 14:36:24 CST

Original text of this message

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