Re: Maxextents = 2 billion?

in Oracle 7.3.3 and onward you can specified maxextents unlimited which will be 2 billions something.

it should not effect building indexes.

if you want to change the maxextents you can enter the commeand alter table tableABC storage (maxextents 249);

chark
"Van Messner" <vmessner_at_netaxis.com> wrote:

> I started work at a site with ten out of tune instances. I was looking
>for objects which had thrown extents and found more than a thousand with
>over 50 extents each.
> As I started to look at the worst of them I discovered ten had
>maxextents set to 2.nnnE+09. I was surprised that Oracle accepted a value
>this high. Can anyone explain why this is allowed?
> Trying to rebuild these indexes resulted in a server crash for each
>attempt. I ended up dropping them and making new ones.
> My guess is that someone was entering storage parameters for maxextents
>= 249 and hit the "e" key which is just below the "4" key.
>
>Thanks for any info
>
>Van
>
Received on Thu Jan 28 1999 - 18:16:06 CST