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

The Import doesn't change the storage parameters of a precreated table.

If your table was created without specifying PCTINCREASE 0 [the default PCTINCREASE is 50], every new extent allocation would increase the Next Extent. hemant

At 09:00 AM 07-08-02 -0800, you 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).

Hemant K Chitale
Now using Eudora Email. Try it !

My home page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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).