Re: DB_NAME in init.ora
From: Tvaresh <tvaresh_at_aol.com>
Date: 1995/11/26
Message-ID: <498tb0$fe2_at_newsbf02.news.aol.com>#1/1
Date: 1995/11/26
Message-ID: <498tb0$fe2_at_newsbf02.news.aol.com>#1/1
To reset the name of a database, try this:
From sqldba (or server manager):
connect internal
alter database backupcontrolfile to trace;
exit
If you change directories to your trace dump directory, the latest file there will contain a script for recreating a controlfile (ls -lt *.trc on unix). By changing the line that starts "create controlfile..." to read "create controlfile SET database "new database name", and then updating your absolute paths to the datafiles, you should be able to change the name and update it in the datafiles. I've done this numerous times and it works fine Received on Sun Nov 26 1995 - 00:00:00 CET