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.

[ Post a follow-up to this message ]

vasant.naidu@gmail.com wrote:
> 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

It seems expdp is removing the destination file and then recreating it.
You need to find a way to alter it's behavior so the people you
need to talk to are at Oracle support or an Oracle forum.

-- ced




>
> 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.
>


--
Chuck Dillon
Senior Software Engineer
NimbleGen Systems Inc.

[ Post a follow-up to this message ]

hi chuck,

thanks for your reply, i will look into it.

regards,
vasant

[ Post a follow-up to this message ]