Re: renaming a database

The proper way to do it is
alter database backup controlfile to trace The trace file will be in the directory pointed to by the user_dump_dest parameter.
Now edit the file changing the database name and run it using whatever version of server manager is appropiate for your otherwise unknown platform.
The other command just does what it does: it renames the global name which is composed of the db_name, and the db_domain parameter.

Hth,

Sybrand Bakker, Oracle DBA

"Lee" <feigenb_at_is01.fas.harvard.edu> wrote in message news:slrn8kcq1k.jfh.feigenb_at_is01.fas.harvard.edu...
> I tried poking around this newsgroup archives and docs to see
> how to rename a database...
>
> I tried doing: alter database <name> rename global_name to <newname>
>
> which claimed to have succeeded but didn't seem to do anything...
>
> So I tried manually moving all the files and replacing all occurrences
> of <name> with <newname> but now when I startup the database I receive
> an ORA-01103 error that the database name doesn't match the database
> name in the control files.
>
> Is there a way to change the database name in the control files at the
> point i'm at? Otherwise if I go back and rename everything to the original
> database name and get that started-up, how do I correctly go about
> renaming the database?
>
> on a (slightly) related note, what's the 'proper' method for deleting a
> database and associated instance completely?
>
> Thanks in advance,
> Lee
>
Received on Tue Jun 13 2000 - 00:00:00 CDT