Question on Table space allocation

From: Naren Chintala <naren_at_att.com>
Date: 1998/02/13
Message-ID: <34E46CC7.6D83@att.com>#1/1

Hi,

1. The db_block_size is 8k (8192 bytes).
2. create table chk (c1 number) tablespace temp storage(initial 8k next 8k minextents 1 maxextents 10 pctincrease 0);
3. SELECT * FROM USER_EXTENTS where SEGMENT_NAME='CHK';

SEGMENT_NAME = CHK
SEGMENT_TYPE = TABLE
TABLESPACE_NAME = TEMP
EXTENT_ID = 0
BYTES = 16384
BLOCKS = 2 Question:

Why does Oracle allocate 2 blocks although the initial extent is set to 8k in the "Create table" statement?

Having created a table with an initial extent of 8k, I would expect to see 1 block and not 2.

Thanks in advance for any help.
Naren Received on Fri Feb 13 1998 - 00:00:00 CST