Re: Rename an Oracle 91 database

In 9i, you can use NID
$nid target=sys/change_on_install dbname=<your new dbname>

after that, shutdown your database, edit your init.ora file, and export ORACLE_SID=<your new dbname>
startup mount;
alter database open resetlogs;

you are on your way.

Hope it helps

"James Culleton" <jculleton_at_eircom.net> wrote in message news:b1oevu$bbs$1_at_kermit.esat.net...
> Hi,
>
> I've installed Oracle 9i server (release 2) 9.2.0.1.0 on a Windows 2000
> server. I created a database called "test" but now I would like to rename
> the database to something else. Is this possible? or would I have to
create
> a new database and move the data across to it.
>
> Any help would be great
>
> James
>
>
Received on Wed Feb 05 2003 - 21:02:56 CST