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: Guang Ju YANG <yangg_at_club-internet.fr>
Date: Tue, 16 Nov 1999 21:37:07 +0100
Message-ID: <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.

abc wrote in message <01bf304f$590df5e0$42b415a5_at_ddd>...
>hi,
>anyone can help on what i should do when I hit this max extentd on table.
>can i increase the extents and is that a formula/command for it ?
>
>thanks.
Received on Tue Nov 16 1999 - 14:37:07 CST

Original text of this message

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