Re: How to rename a database

Try this:

alter database backup controlfile to trace;

shutdown the db

Edit the trace file, change the "REUSE" clause to "SET" and noresetlogs to resetlogs.
remove the startup mount and alter database recover commands. The only command remaining
should be the create controlfile....

Modify the DBNAME in the init.ora and the tracefile to what you want.

delete your control and redo logs.

make sure your oracle sid is now set to your dbname.

svrmgrl
connect internal
startup nomount
@trace.sql (The trace file you generated earlier) alter database open resetlogs;

BINGO! Ps. Back your entire database up first, before you do this. Also, if the database encounters
errors during the "resetlogs", your'll be forced into a recovery loop which you won't be able to
recover through.

Again, back it up first. Received on Sun Jan 25 1998 - 00:00:00 CST