Re: ORACLE_ENV

"Rob Zwartjes" <rzwartje_at_rob.home.nl> wrote in message news:slrn8lbti6.erb.rzwartje_at_rob.home.nl...
> Hello there,
>
> I found out how to invoke my editor vi by default. You will probably see
 big
> deal :) For me it is, because I found it without your help. What I didn't
> find is how to save my scripts at a place where I want it to be saved. At
 the
> moment it is in my home directory. Probably the wright place but I want it
 in
> a directory called 'OracleScripts' and not in my home directory but in the
> oracle home directory so that somebody else can enjoy it to :). What env
> variable do I have to set.
>
> Thanks in advance,
> Rob

I would agree with 'somebody else can enjoy', but I would not agree with Oracle_home. IMO, you should keep that as clean as possible. A better location might be $ORACLE_BASE/admin/$ORACLE_SID/scripts

The ORACLE_PATH env var determines where Oracle is searching for scripts.

Hth,

Sybrand Bakker, Oracle DBA Received on Sun Jun 25 2000 - 00:00:00 CDT