Message-Id: <10707.124190@fatcity.com> From: Suganya Date: Mon, 11 Dec 2000 20:01:13 +0530 Subject: Re: Renaming database-problem with global_name --------------E6E80FF94C6F7F8C2913ECA9 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Sorry Sorry the syntax is Alter database rename global_name to newname.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@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@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). --------------E6E80FF94C6F7F8C2913ECA9 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi
Sorry Sorry the syntax is
Alter database rename global_name to newname.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@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@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).