Oops! Yes, that is what I meant. Thanks for the catch.
-----Original Message-----
Sent: Wednesday, August 07, 2002 8:13 PM
To: Multiple recipients of list ORACLE-L
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).
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: 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).
--
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).
Received on Thu Aug 08 2002 - 13:08:02 CDT