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: EXP with compress=Y

Re: EXP with compress=Y

From: Oracle Data Miner <shyamvaran_at_gmail.com>
Date: 7 Mar 2007 06:07:32 -0800
Message-ID: <1173276452.881042.135290@q40g2000cwq.googlegroups.com>


On Mar 7, 6:09 am, "sybrandb" <sybra..._at_gmail.com> wrote:
> On Mar 7, 11:53 am, OleHa..._at_gmail.com wrote:
>
> > I have made a test of EXP with compress=Y and compress=N.
>
> > The result was 2 dumpfile of the same size. (500 Mbytes).
>
> > Doesn't the compress parameter make the dumpfile smaller ?
>
> > Regards,
> > Ole
>
> No
>
> Please read the docs, and don't ask questions for you can find the
> answer yourself in less than 5 minutes.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Compress = Y is to compress the extends of the table in the dmp file and not to compress the .dmp file. You can pipe the exp process to a compress (zip) process to compress the size in real time Thanks
Shyam Received on Wed Mar 07 2007 - 08:07:32 CST

Original text of this message

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