RE: how to rename a database SID

2001-06-18 Thread Cale, Rick T (Richard)
Title: how to rename a database SID See Note Note:15390.1Subject:How to Determine and Change DB_NAME or ORACLE_SID on MetaLink Here it is below Rick Purpose This entry describes how to find and change the "db_name" for a database, or the ORACLE_SID for an instance, without recreating

Re: how to rename a database SID

2001-06-18 Thread Lucy Lin
just recreate database control file. On Mon, 18 Jun 2001, Andrey Bronfin wrote: HI ! How can i rename a database on NT / UNIX ? Thanks a lot in advance ! -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lucy

RE: how to rename a database SID

2001-06-18 Thread Cale, Rick T (Richard)
You must also change the dbname parameter in the init.ora file -Original Message- Sent: Monday, June 18, 2001 2:18 PM To: Multiple recipients of list ORACLE-L just recreate database control file. On Mon, 18 Jun 2001, Andrey Bronfin wrote: HI ! How can i rename a database on NT /

RE: how to rename a database SID

2001-06-18 Thread Vergara, Michael (TEM)
acle DBA | Guidant Corporation | -Original Message-From: udaycb [mailto:[EMAIL PROTECTED]]Sent: Monday, June 18, 2001 11:22 AMTo: Multiple recipients of list ORACLE-LSubject: RE: how to rename a database SID Hear are the steps (on Unix), Correct me if i am wrong