Re: how to rename a Oracle DB

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 28 Mar 2001 06:25:20 +0200
Message-ID: <tc4a1bfoak9e2@beta-news.demon.nl>

"dba" <roacha_at_stgeorge.com.au> wrote in message news:cUaw6.65$tz.5695_at_nsw.nnrp.telstra.net...
> Guys,
> can anybody spare a few details on how to rename a Oracle db in Unix
> ie: from DB1 to DBnew
>
> Thanks
>
>

alter database backup controlfile to trace find the trace file in your user _dump_dest directory edit the trace to file read
create controlfile *set* database "<new database name>" (don't forget to change the db_name in init<sid>.ora) run the trace file as a sql-script.
That is all

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Mar 27 2001 - 22:25:20 CST