Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: su - oracle -c "script"

Re: su - oracle -c "script"

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 11 Aug 2005 18:58:40 -0700
Message-ID: <bf4638050811185870034b3b@mail.gmail.com> 





Even better!



On 8/11/05, Magnus Andersen <mag.andersen_at_gmail.com> wrote:


> 

> 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

> !

> 

> -- 



Jared Still


Certifiable Oracle DBA and Part Time Perl Evangelist


--
http://www.freelists.org/webpage/oracle-l


Received on Thu Aug 11 2005 - 21:00:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US