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

  • From: jdanton1@xxxxxxxxx
  • To: TESTAJ3@xxxxxxxxxxxxxx,bbel5@xxxxxxxxxxxx
  • Date: Thu, 2 Jul 2009 13:49:06 +0000

Btw, the compress flag in 11g is part of the compression option ($$ or €€)

Joseph D'Antoni
Synthes 
Sent via BlackBerry by AT&T

-----Original Message-----
From: TESTAJ3@xxxxxxxxxxxxxx

Date: Thu, 2 Jul 2009 09:32:53 
To: <bbel5@xxxxxxxxxxxx>
Cc: oracle-l<oracle-l@xxxxxxxxxxxxx>
Subject: RE: W|tee|F? DataPump doesn't work with Unix tee function?


Bambi, what flavor of unix?  I'm curious as to make sure I NEVER use that 
version that won't redirect stderr to stdout.

thanks, joe

_______________________________________
Joe Testa, Oracle Certified Professional 
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.




From:
"Bellows, Bambi (Comsys)" <bbel5@xxxxxxxxxxxx>
To:
"Bradd Piontek" <piontekdd@xxxxxxxxx>
Cc:
"oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date:
07/02/2009 09:23 AM
Subject:
RE: W|tee|F? DataPump doesn't work with Unix tee function?
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx



Bradd – 
 
Thank you for your quick response.  The expdp is crapping out due to 
internal Oracle errors, which, thankfully, are not my issue.  However, 
because of that, no logfile is generated, and, as such, cannot be parsed. 
As for the 2>&1, for whatever reason, that does not work in this flavor of 
Unix.  Wish it did.
 
Thanks again, so much, for your response…
Bambi.
 

From: Bradd Piontek [mailto:piontekdd@xxxxxxxxx] 
Sent: Thursday, July 02, 2009 8:09 AM
To: Bellows, Bambi (Comsys)
Cc: oracle-l
Subject: Re: W|tee|F? DataPump doesn't work with Unix tee function?
 
Have you tried
a) setting LOGFILE i your parameter fiel and parsing that  OR
b) expdp username/incrediblysecretpassword parfile=x.par 2>&1 | tee - 
somefile 

Bradd Piontek
  "Next to doing a good job yourself, 
        the greatest joy is in having someone 
        else do a first-class job under your 
        direction."
 -- William Feather

On Thu, Jul 2, 2009 at 8:01 AM, Bellows, Bambi (Comsys) <
bbel5@xxxxxxxxxxxx> wrote:
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.
 


Other related posts: