RE: W|tee|F? DataPump doesn't work with Unix tee function?
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: <bbel5@xxxxxxxxxxxx>, <oraclelist@xxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Jul 2009 11:54:44 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bellows, Bambi (Comsys)
Sent: Thursday, July 02, 2009 8:32 AM
To: oraclelist@xxxxxxxxxxxxx; 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
***************************************************************************
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.
****************************************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
