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

From: <jdanton1_at_yahoo.com>
Date: Thu, 2 Jul 2009 13:49:06 +0000
Message-ID: 625896705-1246542579-cardhu_decombobulator_blackberry.rim.net-1743457224-_at_bxe1311.bisx.prod.on.blackberry>

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

Date: Thu, 2 Jul 2009 09:32:53
To: <bbel5_at_allstate.com>
Cc: oracle-l<oracle-l_at_freelists.org> 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_at_allstate.com>
To:
"Bradd Piontek" <piontekdd_at_gmail.com>
Cc:
"oracle-l" <oracle-l_at_freelists.org>

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

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_at_gmail.com] 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_at_allstate.com> 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.  

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 02 2009 - 08:49:06 CDT