Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXP with compress=Y
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