Re: su - oracle -c "script"

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 12 Aug 2005 08:14:23 -0400

perhaps you might want to consider sourcing .profile before running sqlplus.

Raj

On 8/11/05, Jared Still <jkstill@xxxxxxxxx> wrote:
> 
> Even better!
> 
> On 8/11/05, Magnus Andersen <mag.andersen@xxxxxxxxx> 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
> 
> 


-- 
------------------------------
select standard_disclaimer from company_requirements where category = 
'MANDATORY';

Other related posts: