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


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

Original text of this message