Re: difference in allocated space

AFAIK everything is rounded to a multiple of 5 blocks. Probably only when you don't specify any explicit allocation as you did in your create table as select statement. I have no database at hand currently, so I can't investigate.

Hth,

--
Sybrand Bakker, Oracle DBA
kor <kor.g_at_hetnet.nl> wrote in message news:OuGowomX$GA.150_at_net003s...
> 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 - 02:48:28 CST