Woohoo - didn't know about that one ! Thx
"charlie cs" <cs3526(no spam)@yahoo.com> wrote in message
news:Afk0a.5568$011.4692_at_nwrddc01.gnilink.net...
> 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 Thu Feb 06 2003 - 13:01:43 CST
