Re: HELP! Running SQLPlus in batch

From: Liz Reen <liz_at_reading.news>
Date: Thu, 1 Apr 1999 15:25:11 -0500
Message-ID: <MPG.116d959f92caa5109896b0@news.supernews.com>

In article <P1wJ2.2$Ja4.130113_at_IConNet>, mkimball_at_rhs.org says...
> I'm trying to run SQLPlus code in batch mode in HP-UX. Any suggestions on
> how to make this happen? Running Oracle 7.3.2 on HP9000 with Unix 10.20.
>
>
>

This runs every night on my 7.3.3 HP-UX instance.

ORACLE_SID=$DB
ORAENV_ASK=NO
. oraenv
ORAENV_ASK=YES su oracle -c "$ORACLE_BIN/sqlplus system/$SYS_PW @$BACKUP_BIN_DIR/coldback.sql"

Liz
--
My real address is L R E E N a t P E R R I E R G R O U P d o t C O M Received on Thu Apr 01 1999 - 14:25:11 CST