Re: export .dmp files grow

In article <3442F84A.7DEC_at_magicnet.net>,   microcon_at_magicnet.net wrote:
>
> I have export setup in cron to fire full database export nightly.
 .dmp
> file is growing about 5MB/day. the .dmp file is now up to 982MB.
 Is
> this normal? How can I make export not produce such a large file?
>
> Steve Walterhouse
> microcon_at_magicnet.net

Try that script

rm -f expipe
/etc/mknod expipe p
compress < expipe > full.dmp.Z &
sleep 1
exp system/manager file=expipe log=full.log full=y rm -f expipe

This will help you .

Shmuel Duek
Infrastructure
D.b.a. & Sysadmin
Aviv Advanced Solutions
8 Lavontin St.
Tel Aviv 65111
Israel

Tel: 972-3-566-0050
Fax: 972-3-566-0020
Mobile: 972-50-715-479
Home: 972-3-550-5226
        O                                       //
       <==-}  ->                      .--._.-^-(.}
        )'                          /{        ( \d
       ./\,                           ) -._.- >
      /  /                             `\    /'

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet