Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Locally managed tablespaces + auto-allocate

Locally managed tablespaces + auto-allocate

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 10 Oct 2000 13:16:44 -0400
Message-Id: <10645.118883@fatcity.com>


I created this table in a locally managed (auto-allocate) tablespace:

create table testext ( c1 char (250)) storage (initial 10M next 10M) tablespace dimd;

When I query the extents:

select * from user_extents where segment_name = 'TESTEXT';

SEGMENT_NA PARTITION_ SEGMENT_TYPE TABLESPACE_NAME EXTENT_ID BYTES BLOCKS
---------- ---------- ------------------ --------------- --------- ---------


TESTEXT               TABLE              DIMD                    0   1048576
64
TESTEXT               TABLE              DIMD                    1   1048576
64
TESTEXT               TABLE              DIMD                    2   1048576
64
TESTEXT               TABLE              DIMD                    3   1048576
64
TESTEXT               TABLE              DIMD                    4   1048576
64
TESTEXT               TABLE              DIMD                    5   1048576
64
TESTEXT               TABLE              DIMD                    6   1048576
64
TESTEXT               TABLE              DIMD                    7   1048576
64
TESTEXT               TABLE              DIMD                    8   1048576
64
TESTEXT               TABLE              DIMD                    9   1048576
64

10 rows selected.    

WHY DOES IT HAVE TO SPLIT THE EXTENT TO MANY SMALL ONES? Received on Tue Oct 10 2000 - 12:16:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US