|
-
that method before was log and error prone, try this.
1) take a backup
2) create a service on the new windows box and start it
3) alter database backup controlfile to trace;
4) shutdown the original db
5) move it to the new box in the locations you want
6) edit the pfile with the parameters for the control file locations / dump directories
7) take the trace file made before, remove all the crap and change the locations of all files using find / replace
8) run the file in sqlplus
9) live long and enjoy
That will save you a lot of time instead of manully moving all files in the data dictionary
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|