Saturday, August 25, 2007

How to move a datafile from one hard disk to another disk

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 :1.alter tablespace users offline;2.copy c:\mydb\users01.dbf e:\mydb\users01.dbf3.alter database rename file 'c:\mydb\users01.dbf' to 'e:\mydb\users01.dbf';4.alter tablespace users online;

No comments:

Google