- did you check the next extent value after you created the table and
before the import? Oracle WILL change extent values for rounding
purposes
- you can get different values by looking at different dba_
tables.... look at dba_tables, dba_segments and dba_extents and you'll
see what I mean.
- 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: 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).
Received on Wed Aug 07 2002 - 13:34:46 CDT
