Re: su - oracle -c "script"

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

Raj

On 8/11/05, Jared Still <jkstill_at_gmail.com> wrote:
>
> 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
>
>

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

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