problem in moving export dump file

[pnrdba]

Dear gurus,
I want to take an export of an unused schema. Due to my system is running out of disk space, i want to take the export in a compressed file. For this, i wrote a small script using bzip2. But its not working. Can any one correct this script please....

$ mkfifo exp_pipe
$ vi cfusexp.sh
#!/bin/bash
cat /u09/mytools/expimp/exp_pipe | /usr/bin/bzip2 --stdout > /u09/mytools/expimp/cfusexp1.dmp.bz2 &
/opt/oracle/product/8.1.6/bin/exp / owner=CFUSADM file=/u09/mytools/expimp/exp_pipe log=/u09/mytools/logs/cfusexp1.log

$nohup cfusexp.sh 1 > cfusexp.out 2>&1 &
$cat cfusexp.out
/bin/nice: cfusexp.sh: No such file or directory


Where am i making mistake? If i'm running it using

$sh cfusexp.sh it's running like a normal export and created a 4G single file. which i can't move to another machine. I want to create through a pipe and export it into a zipped file using bzip2.

Can any one help me out please......

Many thanks in advance

[grjohnson]

http://www.dbasupport.com/forums/sho...highlight=gzip

[pnrdba]

Sorry, i forgot to write my OS and DB version:

Linux 7.1 and Oracle 8.1.6

Thanks again

[pnrdba]

Excellent explaination Mr.Johnson, But, can i apply the same logic for bzip2 to??? b'coz as far as my knowledge goes bzip2 does still more compression than gzip. Is it true, if so, i want to use bzip2 as my server can't accodomate the export dump files. Please help me.......

Thanks a lot for your help