Re: su - oracle -c "script"

  • From: Magnus Andersen <mag.andersen@xxxxxxxxx>
  • To: jkstill@xxxxxxxxx
  • Date: Thu, 11 Aug 2005 21:56:27 -0400

I use the -s in my scripts in combo with a here doc.

su - oracle -c $ORACLE_HOME/bin/sqlplus -s <<!
/ as sysdba
@/apps/oracle/select_user.sql
disconnect
!

-- 
Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates, Inc.
--
//www.freelists.org/webpage/oracle-l

Other related posts: