Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: renaming a database
This is not true. See the other posts in this thread, please.
Lee
On Tue, 13 Jun 2000 21:58:18 GMT, farrellyr5408_at_my-deja.com <farrellyr5408_at_my-deja.com> wrote:
>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