Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Next Extent?
On Mon, 28 Jul 1997 16:31:59 +0100, Hanna LTEIF <hanna.lteif_at_infotechnique.com> wrote:
>HI,
>
>I have this situation, i created a table with theses parameters:
>
> INITIAL : 252k
> NEXT : 28k
> PCTINCREASE : 0%
>
>
> extent_id file_id block_id size in bytes
> --------- ------- -------- -------------
> 0 8 62 266240
>
> 1 8 127 40960
>
> 2 8 137 40960
>
>The question
>------------
>Is it normal that the extent allocated to the table ( 40960 != 28672 )
>is not equal to the one specified in the create table statement.?
Hanna,
Which is the db_block_size of your database?
Best Regards,
-- Luis Santos Banco InterAtlânticoReceived on Fri Aug 01 1997 - 00:00:00 CDT
![]() |
![]() |