Re: Create table statement, weird behavior...

Frank wrote:
>
> Tom, Jonathan,
>
> This is not the point here. The question is:
> why would a mere create table statement allocate 81 extents
> in a dictionary managed TS?
> I wouldn't know the answer, but I think you guys do.
>
> Respectfully yours, etc,
> Frank

If you wanted all the extents to be the same size , then yes, since the create-table would be:

( initial X next X minextents Y pctincrease 0)

where X*Y = total initial size of table required

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."