you can do in this way too
shutdown
copy the file to new location
startup mount
alter database rename file 'old location' to 'new location';
alter database open;
Take a backup of controlfile
remove the existing one from o/s
-Syed
|
Results 1 to 5 of 5
Thread: need to move datafileThreaded View
|
Click Here to Expand Forum to Full Width |