RE: creating the database from another

[Mercadante, Thomas F]

Bunyamin   There are two ways to do this.   The easiest way is to re-create the control files like I told you in the last email.  Before you run the sql script, be sure and edit it to change the location of all of the data files from the E to the D drive.   As far as the "reuse" command, you can ignore it.  If you are going to re-create the control files, you do not have to copy them from the SourceDB to the TargetDB as you will be creating them fresh.   The second way to do this is to copy everything as I told you, and create the Oracle service. Get into svrmgrl and issue a Startup Mount command. Then issue "Alter Database Rename File 'E:filename' to 'D:filename" for each and every datafile in your database (Redo Logs, and all Tablespaces). After you have done this, you should be able to issue an Alter Database Open command, and  you should be all set.   Good Luck!   Tom Mercadante Oracle Certified Professional -----Original Message----- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 3:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: creating the database from another Ok Thomas , thank you but another question rises here for me.         The drive of soucedb is E but my targetdb will be on D drive. How will I manager that ?          And in the control file backup , there is "reuse" keyword . will I neglect it?    Thank you Bunyamin