Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Renaming database-problem with global_name

Re: Renaming database-problem with global_name

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Mon, 11 Dec 2000 19:55:57 +0530
Message-Id: <10707.124188@fatcity.com>

--------------069853066AE4763F173CD263
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi ,
Note : At any cost don't delete the row from global_name

            Alter global_name set global_name = xyz.world. Regards
Suganya

B N RAMAMOHAN wrote:

> Hi,
>
> I renamed my database from ABC to XYZ. But if I select from
> global_name, it still gives ABC.World!
>
> If I select name from v$database it gives XYZ.
>
> why is it so? and how do I correct it?
>
> Regards,
> Mohan
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: B N RAMAMOHAN
> INET: ramamohan.bn_at_tatainfotech.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--------------069853066AE4763F173CD263
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>

<font color="#000000">Hi ,</font>
<br><font color="#000099">Note : At any cost don't delete the row from global_name</font>
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alter global_name set global_name = xyz.world.
<br>Regards
<br>Suganya
<br>&nbsp;
<p>B N RAMAMOHAN wrote:
<blockquote TYPE=CITE>Hi,
<p>I renamed my database from ABC to XYZ. But if I select from
<br>global_name, it still gives ABC.World!
<p>If I select name from v$database it gives XYZ.
<p>why is it so? and how do I correct it?
<p>Regards,
<br>Mohan
<p>--
<br>Please see the official ORACLE-L FAQ: <a href="http://www.orafaq.com">http://www.orafaq.com</a>
<br>--
<br>Author: B N RAMAMOHAN
<br>&nbsp; INET: ramamohan.bn_at_tatainfotech.com
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;
FAX: (858) 538-5051
<br>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists
<br>--------------------------------------------------------------------
<br>To REMOVE yourself from this mailing list, send an E-Mail message
<br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
<br>the message BODY, include a line containing: UNSUB ORACLE-L <br>(or the name of mailing list you want to be removed from).&nbsp; You may
<br>also send the HELP command for other information (like subscribing).</blockquote> Received on Mon Dec 11 2000 - 08:25:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US