RE: slightly ot: nohup disables echo?

From: <k.sriramkumar_at_iflexsolutions.com>
Date: Fri, 27 Feb 2004 09:42:36 +0530
Message-ID: <10898BE7CA96D611988B000802255AAF053BFD04@fmgrt>

Hi Barbara,

        I think that there is problem on the spooling as well. You are spooling into the same file gather_one_table.lis twice .Once from the gather.sh and again from gather_one_table.sql, the contents could be over written.

Best Regards

Sriram Kumar

-----Original Message-----
From: Barbara Baker [mailto:barbarabbaker_at_yahoo.com] Sent: Thursday, February 26, 2004 10:28 PM To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Feb 26 2004 - 22:07:18 CST