Re: Problem with Unix PIPE in my script using oracle export utility

vasant.naidu@xxxxxxxxx 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.
.

Relevant Pages

  • Re: Reading compressed files
    ... (especially unix compress). ... HEADER BODY and FOOTER by open function. ... What you need to do is research each syntax and ...
    (comp.lang.python)
  • Re: Compressed Indexes and insert operations
    ... I just moved into this opening and ... and just wanted some validation. ... There is essentially no chance you are ever going to compress all ... Oracle Ace Director & Instructor ...
    (comp.databases.oracle.server)
  • SUMMARY: compress on rotation of logfiles
    ... > this logfile, and that is what I want to compress... ... If you want to compress you need to keep at least two old ... The syntax is logadm -v filename. ...
    (SunManagers)
  • scp in a multi-piped command?
    ... passing it through gzip or compress | ... gzip -d or uncompress on the other end | ... It is very straightforward to take an Oracle export and pipe it to ... I have read on how to set up ssh in batch mode and am pretty confident ...
    (comp.security.ssh)
  • Re: Import extent size problems
    ... statement on the big database said ... size if compress is N? ... to see what Oracle believes the storage parameters to be. ...
    (comp.databases.oracle.server)