If you want a newer, fresher and quicker method to move a datafile from one disk to another here is the way to do it : Make sure the tablespaces are read-only and then
- alter tablespace users offline;
- copy c:\mydb\users01.dbf e:\mydb\users01.dbf
- alter database rename file 'c:\mydb\users01.dbf' to 'e:\mydb\users01.dbf';
- alter tablespace users online;
then make your tablespaces read write again,
and you're done :-)
More information : Note:115424.1 on MetalinkLabels: datafile, hard disk drive, move, Note 115424 |
Author's note : Thank you all for your supporting letters. You have been a motivation to this web spot's posting. I wish you all the
very best for you and your families for the new year.
: )