Alex, Thanks a lot. Regards, Terry.
Alex Hudghton <alex_at_alenda.freeserve.co.uk> wrote in message
news:382fe548.6658871_at_news.freeserve.net...
> Terry
>
> To change the SID all you need to do is change the name of the
> initSID.ora and set your ORACLE_SID appropriately
>
> To change the name of the database and the SID do the above and this :
>
> In the trace script amend
>
> CREATE CONTROLFILE USE DATABASE "SID" RESETLOGS NOARCHIVELOG
>
> to
>
> CREATE CONTROLFILE SET DATABASE "NEWSID" RESETLOGS NOARCHIVELOG
>
> and change the db_name in the initSID.ora file
>
> Alex
>
>
>
>
>
> On Fri, 12 Nov 1999 22:44:34 -0000, "terry norman"
> <scott_at_tiger9.freeserve.co.uk> wrote:
>
> >Dear all,
> >
> >I found details somewhere of how to copy a database's files to another
> >machine and by doing an "alter database backup controlfile to trace" on
the
> >original machine, then copying over the trace control file and editing it
to
> >change the path names, one could "clone" a new database. I lost the
details
> >but still managed to busk it and get this to work. Obviously this is to
> >create a database for testing, similar to a live one. What it wouldn't
let
> >me get away with however was changing the SID. Does anyone know how to do
> >that please? The "clone" is up and running ok, but I would like it to
have a
> >different SID from the live one to avoid any career limiting accidents.
> >
> >T very much IA.
> >
> >Terry.
> >
> >
>
Received on Tue Nov 16 1999 - 13:39:15 CST