Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Can an Import change the Next Extent on an already created ta
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).
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 - 18:13:24 CDT
![]() |
![]() |