Re: how to rename a Oracle DB

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 28 Mar 2001 18:18:13 +1000
Message-ID: <3ac19e57@news.iprimus.com.au>

It's all done with the 'backup controlfile to trace command', and has been discussed here at length recently. It boils down to: where the trace file says 'reuse database 'DB1' noresetlogs', you substitute 'set database DBnew resetlogs', and where later on it says 'alter database open', you need an 'alter database open resetlogs'.

Regards
HJR "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
>
>
Received on Wed Mar 28 2001 - 02:18:13 CST