Why is NEXT_EXTENT changing all the time?

From: Syltrem <syltrem_at_videotron.ca>
Date: Wed, 24 Jan 2001 14:15:46 -0500
Message-ID: <EJFb6.12044$h67.203598@wagner.videotron.net>

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)

Received on Wed Jan 24 2001 - 13:15:46 CST