RE: Can an Import change the Next Extent on an already created ta

> initial extent for any table/index is 2 blocks, even if you create> the table with a single byte as the initial extent.>

you meant the MINIMUM allocation, right?

"Fink, Dan" <Dan.Fink_at_mdx.com> wrote:
> You may be hitting the situation where Oracle rounds up to a> predetermined> extent size (multiple of 5 blocks ???) regardless of the request. One> thing> to remember is that the initial and next are 'suggestions' and not> law. The> initial extent for any table/index is 2 blocks, even if you create> the table> with a single byte as the initial extent.> > Dan> > -----Original Message-----> Sent: Wednesday, August 07, 2002 11:01 AM> To: Multiple recipients of list ORACLE-L> table > > > 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).> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > Author: Fink, Dan> INET: Dan.Fink_at_mdx.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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_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).