Re: Can an Import change the Next Extent on an already created table

From: Jack Silvey <jack_silvey_at_yahoo.com>
Date: Wed, 07 Aug 2002 10:35:01 -0800
Message-ID: <F001.004ADE91.20020807103501@fatcity.com>

Kevin,

Did you truncate the table before you load it? Truncate will change the NEXT size on the table to the size of the last extent it deallocated. Strange but true.

Also, this means that if you do a CTAS or a direct load into a dictionary managed tablespace without minimum extent set, the parallel query processes will trim the freespace off of the segments they write, and the size that truncate sets might be odd and disasterously small.

hth,

Jack

• Kevin Lange <kgel_at_ppoone.com> wrote:
  > Hey guys;
  > Here is a strange one.
  >
  > I have an 8.0.5 database where I have exported a
  > table. Compress Extents
  > was set to No.
  >
  > On another 8.0.5 database I have pre-created the
  > same table with an
  > Initial and a Next extent of 4M (4194304 Bytes).
  >
  > At this point I imported the table into the new
  > database.
  >
  > Looking at the next extent on the newly imported
  > table I see that its
  > value is now 4218880.
  >
  > I did not think it was possible for an import to
  > change the attributes of a
  > table if it was pre-created.
  >
  > Can anyone shed any light on what might be happening
  > here or if this is
  > 'Normal' operation ?
  >
  > Thanks
  >
  > Kevin
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Kevin Lange
  > INET: kgel_at_ppoone.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do You Yahoo!?
Yahoo! Health - Feel better, live better http://health.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: jack_silvey_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Aug 07 2002 - 13:35:01 CDT