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

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 07 Aug 2002 09:00:48 -0800
Message-ID: <F001.004ADBC6.20020807090048@fatcity.com>

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). Received on Wed Aug 07 2002 - 12:00:48 CDT