Make "exp" be quiet
Date: Tue, 26 Feb 2008 08:24:17 +0100
Message-ID: <6232227.OE5XBVvYtM@michael-schmarck.my-fqdn.de>
Hello.
I'm using exp daily in a cron job to export data from a database. In the cron job, I'm running:
exp ${ora_user}/${ora_pass} FILE=/tmp/test.exp LOG=/tmp/test.exp.log \ DIRECT=Y FULL=Y STATISTICS=NONE > /dev/null
But despite the "> /dev/null", exp writes something on the terminal. Eg.:
Export: Release 9.2.0.4.0 - Production on Tue Feb 26 08:19:41 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
[...]
How can I make "exp" shut up and only "say" something, when there's an error? The problem with exp not being quiet is, that this produces output and thus an email is triggered - I'd rather only get an email, if there's an error.
I'm on Solaris 10.
Michael Received on Tue Feb 26 2008 - 01:24:17 CST