export datapump - problem with unix pipe.

From: <vasant.naidu_at_gmail.com>
Date: 8 Feb 2006 21:25:18 -0800
Message-ID: <1139462718.137217.227050_at_g43g2000cwa.googlegroups.com>

hi,

I have been using export utility to take backup of our database. with the old export utility I used to run the following to successfully take the export dump and at the same time compress the file to save space in our filesystem:

USING OLD EXPORT

---

/etc/mknod /u07/exp/exp_pipe p

/usr/bin/compress < /u07/exp/exp_pipe > /u07/exp/test.dmp.Z &

exp file=/u07/exp/exp_pipe log=/u07/log/test.log parfile=/u07/.exp_par

But recently we upgraded to Oracle 10g which has the datapump utility available with it. But since the syntax for the datapump is different I am finding it difficult to compress the file with the above syntax:

USING EXPORT DATA PUMP

---

/etc/mknod /u07/exp/exp_pipe p

/usr/bin/compress < /u07/exp/exp_pipe > /u07/exp/test.dmp.Z &

expdp system/***** directory=dmpdir dumpfile=exp_pipe logfile=test.log full=y

But when the above statement is fired the expdp starts writing to the exp_pipe rather than
creating a compressed dump file called test.dmp.Z

so as a workaround I will have to first create the dump and then compress it. but this is not what i was looking out for since I do have much space to spare.

any help regarding the same.

regards,
vasant naidu. Received on Thu Feb 09 2006 - 06:25:18 CET