RE: slightly ot: nohup disables echo?

Yes, this will do.
This still suppresses the output from my spooled
".lis" file, but the information I need (the timing
info) is in the log file.

Thanks, Raj!


--- "Jamadagni, Rajendra"
<Rajendra.Jamadagni@xxxxxxxx> wrote:
> 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
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://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
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>
-----------------------------------------------------------------


__________________________________
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: