Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: hit max extents on table
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 emailReceived on Thu Nov 18 1999 - 14:36:24 CST