Re: Why is NEXT_EXTENT changing all the time?

Syltrem wrote:

> 
> I am trying (hard!) to get same size extents throughout my tablespace, but
> Oracle *8.0.5.1) won't let me do it.
> 
> NEXT_EXTENT keeps changing for about 20 tables (out of 1500). Please someone
> have a look at the following sequence and tell me what I do wrong or do not
> understand!
> Note: I picked a bad example maybe (numbers are look alike)
> I want extent size = 160 (one-sixty) and Oracle changes for 168
> (one-sixty-eight)
> a) table created with extent=160k
> b) import data
> c) extent now 168
> d) truncate table
> e) extent back to 160
> 
> Thanks!
> 
> SQL> select owner,next_extent/1024 from dba_tables where
> table_name='GEM_RELATIO
> NS';
> 
> OWNER                          NEXT_EXTENT/1024
> ------------------------------ ----------------
> FINANCE                                     160
> 
> $ imp finance/pwd ignore=y file=$1$DGA56:[SYLVAIN]MITFINSMALL.DMP
> tables=GEM_RELATIONS
> Import: Release 8.0.5.1.0 - Production on Wed Jan 24 13:50:36 2001
> (c) Copyright 1998 Oracle Corporation.  All rights reserved.
> Connected to: Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production
> With the Partitioning option
> PL/SQL Release 8.0.5.1.0 - Production
> 
> Export file created by EXPORT:V08.00.05 via conventional path
> . importing FINANCE's objects into FINANCE
> . . importing table                "GEM_RELATIONS"       1095 rows imported
> About to enable constraints...
> Import terminated successfully without warnings.
> 
> $ SQLPlus sys/pwd
> SQL*Plus: Release 8.0.5.0.2 - Production on Wed Jan 24 13:51:16 2001
> (c) Copyright 1998 Oracle Corporation.  All rights reserved.
> Connected to:
> Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production
> With the Partitioning option
> PL/SQL Release 8.0.5.1.0 - Production
> 
> SQL> select owner,next_extent/1024 from dba_tables where
> table_name='GEM_RELATIONS';
> 
> OWNER                          NEXT_EXTENT/1024
> ------------------------------ ----------------
> FINANCE                                     168
> 
> SQL> truncate table finance.gem_relations;
> 
> Table truncated.
> 
> SQL> select owner,next_extent/1024 from dba_tables where
> table_name='GEM_RELATIONS';
> 
> OWNER                          NEXT_EXTENT/1024
> ------------------------------ ----------------
> FINANCE                                     160
> 
> --
> Syltrem
> http://pages.infinit.net/syltrem (OpenVMS Web Site)

Is the default storage on the tablespace set to something other than 0 for PCT_INCREASE? Alternately, is the table itself set to a non-zero pct_increase?

.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................
.......................................................

v.......................................................


.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................

.......................................................