Re: exp73 dumpparam for unlimited extents?

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: sfaroult_at_oriole.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).