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: abc <oldman_at_hotmail.com>
Date: 17 Nov 1999 14:51:10 GMT
Message-ID: <01bf310a$d7018be0$4fb415a5@ddd>


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.
>
Received on Wed Nov 17 1999 - 08:51:10 CST

Original text of this message

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