Monday, June 11, 2007

How to move a datafile from one Disk To Other

Connect to SQL as Sysdba then Follow the following steps

  1. alter tablespace users offline;

  2. copy c:\Oracle\users01.dbf e:\Oracle\users01.dbf

  3. alter database rename file 'c:\oracle\users01.dbf' to 'e:\oracle\users01.dbf';

  4. alter tablespace users online;