Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export- Compress y/n

Re: Export- Compress y/n

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Sun, 22 Nov 1998 14:48:45 +0800
Message-ID: <3657B3CD.39C1@bhp.com.au>


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 --



Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad" Received on Sun Nov 22 1998 - 00:48:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US