Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!opentransit.net!wanadoo.fr!freenix!isdnet!isdnethub!not-for-mail
From: "Yann CAUCHARD" <yann.cauchard@spcconsultants.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: global name question
Date: Thu, 15 Nov 2001 17:47:52 +0100
Lines: 29
Message-ID: <9t0rl0$hok$1@news2.isdnet.net>
References: <hgo7vt8mcjjip3shgcd8djbjpsagplnsgv@4ax.com>
NNTP-Posting-Host: 195.3.48.202
X-Trace: news2.isdnet.net 1005842912 18196 195.3.48.202 (15 Nov 2001 16:48:32 GMT)
X-Complaints-To: abuse@isdnet.net
NNTP-Posting-Date: 15 Nov 2001 16:48:32 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Xref: easynews comp.databases.oracle.server:125097
X-Received-Date: Thu, 15 Nov 2001 10:07:35 MST (news.easynews.com)

No very nice, but may be you can try :

update global_name set global_name='ORCL8';

But it doesn't answer the question : why is not already ORCL8 ?

Yann

Luc Bosman a écrit dans le message ...
>Here is the scenario
>in init.ora: db_domain=  (not set)
> db_name=ORCL8
>
>select * from global_name give 'ORACLE'
>How is it possible? And how correct it? I would like 'ORCL8' in
>place.
>
>--
>Luc Bosman
>DEV/2000 Software Engineer
>l.bosman@iile.be
> ----------------------------------------------------
>|  -°)                                          (°-  |
>|  /\\  Linux the choice of the GNU generation  //\  |
>| _\_v                                          v_/_ |
> ----------------------------------------------------
>