Re: host_name from v$instance mystery

Did you specify domain_name = dev.mycompany.com or similar in init.ora in the instance's machine where you have the full qualification?

Martin

kal121_at_my-deja.com wrote:
>
> Where does Oracle get the host_name in the v$instance table?
>
> The reason I ask is, on one machine, the host_name is simply the
> machine name, for example: DARTHVADER
>
> On another machine, the host_name is the fully qualified domain name,
> for example: LEIA.DEV.MYCOMPANY.COM
>
> Why is this? I like to display the host_name in my prompt, but having
> the full name display is too long! How can I fix it so that it only
> shows LEIA, not LEIA.DEV.MYCOMPANY.COM?
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
  Received on Fri Apr 14 2000 - 00:00:00 CDT