just recreate the controlfile with set dbname won't change the dbid. On Fri, 24 Sep 2004 08:56:44 -0400, nelson.petersen@xxxxxxxxxxxxxxx <nelson.petersen@xxxxxxxxxxxxxxx> wrote: > You might want to add the following at the end of your cloning process. > > 'alter database rename global_name to new_name.domain_name;' > > (SELECT * FROM GLOBAL_NAME; to see the current value.) > > Regards, > Nelson Petersen > > > > > -----Original Message----- > From: Ganesh Raja [mailto:ganesh.raja@xxxxxxxxx] > Sent: Thursday, September 23, 2004 7:00 PM > To: bspears@xxxxxxxxxxxxxxxxx > Cc: oracle-l@xxxxxxxxxxxxx > Subject: Re: Cloning gurus. > > All the datafiles also have a DBID on them that gets Reset when the > Controlfile is Recreated with set Database Name Call. > > HTH > > Cheers > Ganesh R > > On Thu, 23 Sep 2004 16:46:42 -0400, Spears, Brian > <bspears@xxxxxxxxxxxxxxxxx> wrote: > > I checked and only the controlfiles have the db name... And I am > guessing > > these get the newnames on the new clone? > > > > Brian > > > > > > > > > > -- > > //www.freelists.org/webpage/oracle-l > > > -- > //www.freelists.org/webpage/oracle-l > > > -- > //www.freelists.org/webpage/oracle-l > -- Regards Zhu Chao www.cnoug.org -- //www.freelists.org/webpage/oracle-l