RE: W|tee|F? DataPump doesn't work with Unix tee function?

From: Randy Johnson <oraclelist_at_sbcglobal.net>
Date: Thu, 2 Jul 2009 08:27:12 -0500
Message-ID: <002901c9fb18$cf1ed120$6d5c7360$_at_net>



I may be assuming incorrectly that you want to sent the output to gzip or compress which is a common approach with exp. If you just want to see the contents of the dump file it might help you to know the output from Datapump is XML format. You might be able to get what you want by just viewing the file directly or perhaps an XML viewer.  

Hope this helps.  

                -Randy Johnson

 

 

Sorry to be the bearer of bad news but you are right, Datapump doesn't work with tee. I believe its because the output is coming from the Oracle shadow process directly rather than being sent back through your exp process. It's simply not supported in 10g. Version 11 supports compression with a command line switch.  

                -Randy Johnson 

 

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bellows, Bambi (Comsys)
Sent: Thursday, July 02, 2009 8:02 AM
To: oracle-l
Subject: W|tee|F? DataPump doesn't work with Unix tee function?  

Friends -  

I am trying to mechanize a datapump process and send an email if it fails. Problem is that  

expdp username/incrediblysecretpassword parfile=x.par|tee -a somefile  

does not, in fact, tee -a anything! I can do  

expdp username/incrediblysecretpassword parfile=x.par >somefile 2>somefile  

but that disables output to the screen, which the user running the job certainly wouldn't like. So. three questions.  

  1. How do you get output onto the screen and into a file without using tee?
  2. How in the world did Oracle manage to disable tee in the first place?
  3. Why would they want to?

Other than that, best wishes to all my good friends for a lovely holiday and/or quiet list day!  

Thanks!

Bambi.

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4209 (20090702) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4209 (20090702) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 02 2009 - 08:27:12 CDT

Original text of this message