Hi everyone
>
> I can't understand the following difference
>
> i have a tablespace with default storage :
>
> TABLESPACE_NAME INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT
> PCT_INCREA STATUS CONTENTS
> ------------------------------ ---------- ---------- ---------- ----------
> ---------- --------- ---------
> ONTWHOREN_DATA_SMALL 131072 131072 1 1024
> 0 ONLINE PERMANENT
>
> When i create a table when no storage clause
>
> SQL> CREATE TABLE ONTWHOREN.TEST AS SELECT * FROM APPL_GEBR;
>
> Table created.
>
> SQL>
>
> then i query the dba_segments view :
>
> OWNER SEGMENT_NAME TABLESPACE_NAME BYTES
> BLOCKS INITIAL_EX EXTENTS
> ----------------- ------------------- ------------------------------
> ---------- ---------- ---------- ----------
> ONTWHOREN TEST ONTWHOREN_DATA_SMALL
> 143360 35 131072 1
>
>
>
> I see a difference off 3 oracle blocks (db_block_size = 4096);
> instead of the 32 blocks i expected there are 35 blocks.
>
> anyone with a logical explanation ?
>
> thanks
>
> g.kor
> rdw vehicle administration
> the netherlands
> gkor_at_rdw.nl
>
Received on Fri Jan 14 2000 - 03:34:48 CST
