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_at_espn.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> Barbara Baker
> Sent: Thursday, February 26, 2004 11:58 AM
> 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
>
>
> 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
>
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
-----------------------------------------------------------------
Received on Thu Feb 26 2004 - 14:04:27 CST