In essence you use the ALTER DATABASE BACKUPCONTROLFILE TO TRACE command to
create a control file recreation scipt, edit the script to set the name you
want, shutdown the database, change the definition for ORACLE_SID and then
use the script to rebuild the control file and restart the database
<mailto:manash_at_superlinknet> wrote in message
news:7p4iep$kss$1_at_earth.superlink.net...
> Hi,
>
> I have to change the sid of my database,
> I am not very clear about the steps
> should be followed to do this job.
>
> I need help from any body has experience
> of this nature or has any knoledge of this operation,
> please
>
> thanks in advance
> dhruba
>
>
Received on Sun Aug 15 1999 - 14:36:57 CDT
