RE: Renaming Oracle Instance

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Tue, 22 Aug 2000 23:54:18 -0700
Message-Id: <10598.115321@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C00CCE.F51479D0
Content-Type: text/plain;

charset="iso-2022-jp"

recreate control file
alter database rename global_name to ORA8

u are all set

hth
deepak

-----Original Message-----
From: magesh [mailto:magesh_at_garoo.ne.jp] Sent: Wednesday, August 23, 2000 12:04 AM To: Multiple recipients of list ORACLE-L Subject: Renaming Oracle Instance

Hi All

How to rename an Oracle Instance , Currently my Oracle instance is ORCL , Now i want to change it as ORA8.

Regards
Magesh

------_=_NextPart_001_01C00CCE.F51479D0
Content-Type: text/html;

charset="iso-2022-jp"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-2022-jp">

<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=328155806-23082000><FONT face=Arial color=#0000ff size=2>1.
recreate control file</FONT></SPAN></DIV>
<DIV><SPAN class=328155806-23082000><FONT face=Arial color=#0000ff size=2>2.
alter database rename global_name to ORA8</FONT></SPAN></DIV>
<DIV><SPAN class=328155806-23082000><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=328155806-23082000><FONT face=Arial color=#0000ff size=2>u are
all set</FONT></SPAN></DIV>
<DIV><SPAN class=328155806-23082000><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=328155806-23082000><FONT face=Arial color=#0000ff
size=2>hth</FONT></SPAN></DIV>
<DIV><SPAN class=328155806-23082000><FONT face=Arial color=#0000ff
size=2>deepak</FONT></SPAN></DIV>
<DIV><SPAN class=328155806-23082000></SPAN><FONT face=Tahoma><FONT face=Arial
color=#0000ff size=2></FONT><FONT face=Arial color=#0000ff size=2></FONT><BR><FONT size=2><SPAN class=328155806-23082000><FONT face=Arial color=#0000ff> </FONT></SPAN>-----Original Message-----<BR><B>From:</B> magesh [mailto:magesh_at_garoo.ne.jp]<BR><B>Sent:</B> Wednesday, August 23, 2000 12:04 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Renaming Oracle Instance<BR><BR></FONT></DIV></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">

  <DIV><FONT face=Arial size=2>Hi All</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>&nbsp; How to rename&nbsp;an Oracle Instance ,

Currently my Oracle instance is ORCL , Now i want to change it as ORA8.</FONT></DIV>

  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>Regards</FONT></DIV>
  <DIV><FONT face=Arial size=2>Magesh</FONT></DIV></BLOCKQUOTE></BODY></HTML>

Received on Wed Aug 23 2000 - 01:54:18 CDT