Re: Changing database name

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 17 Mar 2001 13:21:50 +0100
Message-ID: <tb6liv2p92r936@beta-news.demon.nl>

"roma" <roma_at_obl.kh.enrgy.gov.ua> wrote in message news:3AB35033.627CD81F_at_obl.kh.enrgy.gov.ua...
> Help please!
>
> How can I change a database name on Oracle 8.0.5?
>

fire up svrmgr
connect internal
issue
alter database backup controlfile to trace find the trace file in your udump directory. edit it , changing
create controlfile database ..
into
create controlfile SET database ..
Also make sure your db_name init.ora parameter is changed. Also remove any comments from this file and rename it to a file with a .sql extension
Now shutdown the database
and 'run' the trace file.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Mar 17 2001 - 06:21:50 CST