Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: hit max extents on table
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
![]() |
![]() |