Did you check to see that the next extent was really 4M before the export?
Maybe the number was rounded up for some reason and was that way before the
export.
> -----Original Message-----
> From: Kevin Lange [mailto:kgel_at_ppoone.com]
> Sent: mercredi, 7. août 2002 10:01
> To: Multiple recipients of list ORACLE-L
> Subject: Can an Import change the Next Extent on an already created
> 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 ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.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 - 17:15:51 CDT
