Re: RE: rename database

From: Gene Sais <Gsais_at_co.palm-beach.fl.us>
Date: Tue, 06 Mar 2001 13:55:51 -0800
Message-ID: <F001.002C52B9.20010306134731@fatcity.com>

Lisa - You can always keep the same db name on a different server and change the tnsnames.ora file to reference either db server. also set global_names=false. just my $.02

>>> vgorbounov_at_simplyengineering.com 03/06 4:02 PM >>>
Hi, Lisa,
You can change database global name, but db_name change requires controlfile to be recreated.  

Vadim Gorbounov
Oracle DBA

-----Original Message-----
Sent: Tuesday, March 06, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L

Hello everyone -

Is it possible to rename a database without recreating the controlfile? I have a feeling it isn't, but can someone verify?

Thanks

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174 
F: 954.484.2933 
C: 954.658.5849 

http://www.qode.com <http://www.qode.com>

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

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).

Received on Tue Mar 06 2001 - 15:55:51 CST