Re: Changing database name problem

Hi

   You can change the name of the database by making only one change in your create control file script and changing its name in init.ora file .

  You have done one mistake where ypun changed the name in create control file scripts you have to replace reuse with set. so it will look like this

create crontrolfile set database "new name "

 You can try it and it should work.

 Best wishes

  Bye

 Aamer Janjua

Elias Sanjuan Lopez wrote:

> Hello everybody
>
> We are trying to change the database name from an existing database. We
> followed the next setps:
>
> - We have obtained a file from the comand alter database backup
> controlfile to trace. We modified the line where appears the old
> database name. This line was: create crontrolfile reuse database "zzzz"
> ...... and we modified the old name.
> - We have startup the database without mounting.
> - Then we execute the command: alter database rename global_name xx.yy;
> - We modified the init.....ora and rename it as initxx.ora. The
> parameter db_name inside was modified too.
> - Then we use the file obtained in the first step and the following
> error appears: "the Database name found in common line does not match
> the database name in the file file header"
>
> Anybody can help us?
>
> Thanks.
>
> Jaime.
Received on Mon Jan 03 2000 - 07:24:15 CST