|
Home > Archive > Unix Programming > February 2006 > Problem with Unix PIPE in my script using oracle export utility
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Problem with Unix PIPE in my script using oracle export utility
|
|
| vasant.naidu@gmail.com 2006-02-13, 2:52 am |
| 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.
| |
| Chuck Dillon 2006-02-13, 6:04 pm |
| 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.
| |
| vasant.naidu@gmail.com 2006-02-14, 7:49 am |
| hi chuck,
thanks for your reply, i will look into it.
regards,
vasant
|
|
|
|
|