Re: renaming a database

The only way to rename a database is to recreate it.

In article <slrn8kcq1k.jfh.feigenb_at_is01.fas.harvard.edu>,   feigenb_at_is01.fas.harvard.edu (Lee) wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jun 13 2000 - 00:00:00 CDT