Re: How to change ORACLE_SID?

1. "alter database backup controlfile to trace"
2. Edit this controlfile Change Create-Command the createcomand looks like "create controlfile set <new-databasename> ... RESETLOGS
3. change the open command alter database open resetlogs
4. create an new controlfile

Of course you should alter some filenames

5. Now you should change the DB-Name in init.ora and adapt the Enviromentsettings (Regestry, etc.)

Violin wrote:

> Hello,
> I have 2 databases Oracle7.3 ,one on NT4.0 and
> the other on NetWare 4.10,
> 'Cause the 2 databases were created when installing,
> the ORACLE_SID were both ORCL.
> Now I want to change the ORACLE_SID of them,
> could any one teach me how to change ORACLE_SID?
> Thank you in advance.
> Please Cc to: violin.hsiao_at_mail.pouchen.com.tw
>
> Violin.
Received on Mon Oct 19 1998 - 01:53:17 CDT