Extents & MAXEXTENTS

From: Md Irfan <irfan_pk_at_hotmail.com>
Date: 7 May 2002 06:19:36 -0700
Message-ID: <c42168e7.0205070519.6f652fbb@posting.google.com>

Hi,
I would like to know the default Maxextents storage clause of Create Table. I have for example two tables:

TABLE_NAME INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT PCT_INCREA

T1             262215680  125849600          1        121       50
T2             178319360   83894272          1        121       50

Can anyone help me in understanding if initial_extent is not defined while creating table, how does the value of initial_extent for T1, T2 come from?
When I query, dba_extents I get extent_id is 0 (zero) for all the tables. I have noticed that initial_extent keeps on growing but no changes in extent_id (always zero). Is that the data written in the first extent only.
Also what in case if table needs extents more than max_extents. Thanks... Received on Tue May 07 2002 - 08:19:36 CDT