Re: How to rename a database?

From: Frank Bommarito <75662.112_at_CompuServe.COM>
Date: 1996/05/15
Message-ID: <4nd732$3lv$1_at_mhafc.production.compuserve.com>#1/1

Couple of steps.

1. Startup the database with existing name
2. alter database backup controlfile to trace;
3. shutdown database
4. edit the db_name initialization parameter to = the new name
5. edit the trace file in the UDUMP area - change create control 

file line -- where = database - put " set database" (i.e. add the word set)
6. Startup nomount
7. execute the create control file statement from the trace file with your one modification
8. startup the database -- you now have a new name..  

You may want to adjust the SID as well - but - it is not necessary.

Frank Received on Wed May 15 1996 - 00:00:00 CEST