Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export- Compress y/n
LEVINIR wrote:
>
> I have calculated initial extent for table=500M. It this point just 1/3 of
> initial extent is filled. What parameter should be used COMPRESS=Yor N?
Assuming that you have carefully mapped out the size of all your objects (take a look at the tech papers on www.europa.com/~orapub for some good advice on this), then in almost all situations, exp compress=n is preferred...otherwise you may lose any optimal sizing characteristics you used...
HTH --