Re: Changing dbname of startup database

From: Peter Gill <peter_at_gillp.freeserve.co.uk>
Date: Sun, 28 Mar 1999 17:41:07 +0100
Message-ID: <7dllan$4l9$1@news6.svr.pol.co.uk>

Thanks for this. I've tried just changing the alias but this didn't work. When you say 'clone' the database, do you mean create a new set of datafiles based on the current one, or is it possible to attach the existing datafiles to a new control file with a different dbname?

Thanks again.

David Gustafson wrote in message <36FD688C.5A3DCFC1_at_ibm.net>...
>You have two options.
>
>1.) If the "oracle" database is distinct on the server simply change the
alias
>name in tnsnames.ora. By default the alias name is the same as the DB name.
>2.) After DB creation clone the database to a new DB name.
>
>Dave...
>
>Peter Gill wrote:
>
>> I want to use the startup database that the Oracle Installation program
>> creates, but I need to give it a different name (dbname) (otherwise I get
>> problems when I try to create database links to other databases on the
>> network which also have the default dbname of 'oracle').
>>
>> Does anyone know how I can change the dbname either before I install
Oracle
>> or afterwards? Or is there another way round this problem?
>>
>> Thanks.
>
Received on Sun Mar 28 1999 - 10:41:07 CST