Re: Is it possible to copy one db to another if the SID is different

2002-10-09 Thread helpdesk . hcl
Hi, Please use SET in create controlfile statement if you are going to change the DB Name. CREATE CONTROLFILE REUSE SET DATABASE TEST RESETLOGS ARCHIVELOG thnx Venkat

Re: Is it possible to copy one db to another if the SID is different

2002-10-09 Thread Stephane Faroult
CHAN Chor Ling Catherine (CSC) wrote: Hi, Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? I need to clone Oracle Applications 11I from one machine (source instance:PROD) to another (target instance:TEST). I

RE: Is it possible to copy one db to another if the SID is different

2002-10-09 Thread Vergara, Michael (TEM)
Dear New Bee: We do this all the time, and the problem you're having is the one that I tripped over my first time, too. There is an important word missing from your command. It's not... CREATE CONTROLFILE REUSE DATABASE TEST RESETLOGS ARCHIVELOG ...it is ... CREATE CONTROLFILE REUSE SET