Re: query oracle_home in sqlplus
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Fri, 19 Sep 2003 14:05:50 +0200
Message-ID: <1063972796.518319_at_news.thyssen.com>
Date: Fri, 19 Sep 2003 14:05:50 +0200
Message-ID: <1063972796.518319_at_news.thyssen.com>
"Michael Willer" wrote...
> Guido Konsolke wrote:
>
> >
> >
> > Hi Peter,
> >
> > $ORACLE_HOME is a parameter that contains the home directory
> > of an oracle installation. Could you please explain:
> > - what are you trying to do and why
> > - are you on client or server side
> > - what is your oracle version
> > - what is your OS?
> >
> > UTL_FILE package *could* be what you're looking for.
> >
> > Greetings,
> > Guido
> >
> >
> Global name can be set to whatever textstring you want with the
command:
>
> alter database rename global_name to whateveryouwant;
>
>
> Michael Willer
> Cybercom Group
>