How to suppress Oracle old,new messages in SQLPLUS ?
From: zw <MPC8250_at_gmail.com>
Date: Sat, 2 Feb 2008 22:23:35 -0800 (PST)
Message-ID: <857a15c9-ad5e-4deb-aeb3-9c6502edb026@v17g2000hsa.googlegroups.com>
nohup ./B.sh $ts $locate $5 $7 $3 $4 $9 &
Date: Sat, 2 Feb 2008 22:23:35 -0800 (PST)
Message-ID: <857a15c9-ad5e-4deb-aeb3-9c6502edb026@v17g2000hsa.googlegroups.com>
Hi
I have the following:
shell script A.sh
nohup ./B.sh $ts $locate $5 $7 $3 $4 $9 &
shell script B.sh
:
:
while 1
sqlplus -s $5/$6@$7 @c.sql $3 >> fc1
end
When I tail -f fc1, I get
old 1: select count(*) from v$session a where a.username='&1' and
a.status='AC
TIVE'
new 1: select count(*) from v$session a where a.username='test' and
a.status='ACTIVE'
0
I just want to see 0 appended to fc1 file.
Thanks Received on Sun Feb 03 2008 - 00:23:35 CST