Re: base 2 or base 10?

Dougie,

You are most likely correct. Long day, long time since I did this particular exercise.

Dave,

Create your table with extent size of 1M or 20M and then check to see what size Oracle actually used to create it. My guess is that for those sizes, it will be exactly what you asked for. If you'd used 10000 then it would round since that isn't "binary" according to your definition. Anyway the point is to check to see what Oracle actually did rather than assume. :-)

Dennis

On 9/28/05, Dougie McGibbon <DMcGibbon_at_tollnz.co.nz> wrote:
>
>
> > Oracle will round the extent size up to an even block size. So you
> > should use binary for extent sizes.
>
> I always thought Oracle rounded up to the nearest factor of five blocks -
> ask for 7 blocks and you got 10 ???
>
>
> Dougie McGibbon

--
http://www.freelists.org/webpage/oracle-l