Re: How to change ORACLE_SID?

Why not change the instance name instead?

Stop database.
Set ORACLE_SID to new a new value.
Rename init<OLD_SID>.ora to init<NEW_SID> and restart database ifile in the new initfile still refers to the config<SID>.ora file where

the db_name is still set to the old ORACLE_SID.

Petter Henrik
Gocha Mchedlishvili wrote:

> Why don't you give us another solution?
> I'll be glad to hear it
>
> Gocha
>
> John Durst wrote in message <362A07E5.1CDA315_at_sky.net>...
> >Reinstall the database?????? That's rediculous.
> >
> >Gocha Mchedlishvili wrote:
> >
> >> Reinstall the database
> >>
> >> Gocha
> >
> >
> >
Received on Wed Oct 21 1998 - 14:22:30 CDT