Re: query oracle_home in sqlplus

From: Michael Willer <no.spam_at_please.com>
Date: Fri, 19 Sep 2003 13:04:16 +0200
Message-ID: <3f6ae2da$0$13257$edfadb0f_at_dread15.news.tele.dk>

Guido Konsolke wrote:

> "peterlin" <member35081_at_dbforums.com> wrote...
>

>>Hi,
>>
>>    I wonder wether I have the wrong concept of $ORACLE_HOME, in my

>
> mind
>

>>    the $ORACLE_HOME is a directory like 'D:\oracle\ora92' where

>
> oracle
>

>>    is installed.
>>
>>    However select global_name from global_name returned
>>    'computername.domain'.
>>
>>    Does I have a wrong concept ?
>>
>>Thanks!
>>
>>Peter
>>
>>--
>>Posted via http://dbforums.com

>
>
> 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 Received on Fri Sep 19 2003 - 13:04:16 CEST