Don Granaman wrote: > > With compress=N, you will get essentially the same mish-mash of extents you > had previously -
Hmmm, that's hair-splitting, but if you reimport into a tablespace from which all objects have been dropped and that you have coalesced, you will have the same number of extents but they will all be created one after the other - as many 'logical' extents as before, but as far as the 'macroscopic' (i.e. let's forget about how the OS deals with its blocks and what happens on the disk) physical level is concerned there will hardly be any difference with compress=Y immediately after creation. That said, nobody cares much about external fragmentation anyway ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
