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!
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
