Hi Patrick, I recently faced similar problem. I was asked to clone the database to different host with different SID. I started by restoring data from backup and then I was going to recreate the control file to change the SID. Fortunately I found better solution by Tim Hall which I used to change the database SID: http://www.oracle-base.com/articles/9i/DBNEWID.php Regards, Sve patrick obrien wrote:
-- //www.freelists.org/webpage/oracle-l |