RE: W|tee|F? DataPump doesn't work with Unix tee function?
Date: Thu, 2 Jul 2009 11:54:44 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E3606587EC4_at_CWYMSX04.Corp.Acxiom.net>
I'm running on Linux RHEL and it seems to work fine for me (10.2.0.4):
% expdp dherri/<password> directory=data_pump_dir tables=dch_itest 2>&1 | tee x.log
Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 02 July, 2009 11:50:38
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "DHERRI"."SYS_EXPORT_TABLE_01": dherri/******** directory=data_pump_dir tables=dch_itest Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 0 KB ORA-39166: Object DCH_ITEST was not found. ORA-31655: no data or metadata objects selected for job Job "DHERRI"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at 11:50:41
% ls -ltr
-rw-r--r-- 1 oracle dba 730 Jul 2 11:50 export.log
-rw-r--r-- 1 oracle dba 723 Jul 2 11:50 x.log
The file "x.log" gives the same output as what has been cut-pasted above from my putty session.
Is this the same thing you're trying to do?
David C. Herring | DBA, Acxiom Automotive
630-944-4762 office | 630-430-5988 cell | 630-944-4989 fax 1501 Opus Pl | Downers Grove, IL, 60515 | U.S.A. | www.acxiom.com
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:32 AM
To: oraclelist_at_sbcglobal.net; oracle-l Subject: RE: W|tee|F? DataPump doesn't work with Unix tee function?
Wow. How weird is that?
Thanks Randy!
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Randy Johnson Sent: Thursday, July 02, 2009 8:24 AM
To: 'oracle-l'
Subject: RE: W|tee|F? DataPump doesn't work with Unix tee function?
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...
- How do you get output onto the screen and into a file without using tee?
- How in the world did Oracle manage to disable tee in the first place?
- 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.
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4209 (20090702) __________
The message was checked by ESET NOD32 Antivirus.
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank You.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 02 2009 - 11:54:44 CDT