Re: Change the DB_NAME How to ?

Erik Oosterling wrote:

> Hello all,
>
> I made a small mistake and dropped all my news groups. So here we are
> again.
>
> Is there a way to change the database name used in the INIT.ORA
>
> now it is:
>
> DB_NAME = ORACLE
>
> But i want to use
>
> DB_NAME = TEST or
> DB_NAME = PROD
>
> Okay i know you have to the db a name when you create him but it was
> not job to create them but it is my job to support them.
>
> PLEASE HELP
>
> Erik Oosterling
>
> The Netherlands

  alter database rename global_name to <newdbname>.<domain>;

--
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.