RE: slightly ot: nohup disables echo?
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Feb 2004 12:07:03 -0500
we prefer to do something like ...
nohup /oracle/gather.sh > /oracle/gather.log 2>&1 &
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
select standard_disclaimer from company_requirements;
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Barbara Baker
Sent: Thursday, February 26, 2004 11:58 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: slightly ot: nohup disables echo?
Hi, list!
Solaris 9 Oracle 9.2.0.4
Is there something about nohupping a script that will
cause "set echo" in sqlplus to not work?
I'm trying to load a bunch of tables, and I'd like to
run them in background. When I run the script in
sqlplus, I see all my output (including the time
stamps, which I really need.)
When I run in background, the ".lis" file is missing
the timestamps.
Am I missing something obvious?
Here's a quick kludge that should show what I'm going.
Thanks for any help.
Barb
nohup /oracle/gather.sh 1> /oracle/gather.log &
=====> gather.sh:
#!/bin/ksh
#set the environment
. /oracle/set_ent9i.sh
sqlplus -s user/pwd << EOF
set echo on
spool gather_one_table.lis
select name from v\$database;
@gather_one_table.sql
exit
EOF
=====>gather_one_table.sql:
SET SERVEROUTPUT ON SIZE 1000000
SET FEEDBACK 1
SET TIME ON
SET ECHO ON
HOST date
SPOOL gather_one_table.lis
exec dbms_stats.gather_table_stats -
( ownname=> 'ADVDB', -
tabname => 'XMLS_HIERARCHY', -
cascade => TRUE -
);
HOST date
exit
=====> gather_one_table.lis output:
$> more gather_one_table.lis
-- EXECUTE dbms_stats.gather_schema_stats PROCEDURE
PL/SQL procedure successfully completed.
__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
