數據庫open狀態下，如何修改數據文件路徑（可用于改名改路徑）

數據庫open下，將users表空間下的數據遷移到/home/oracle/dsk1下（可用作為改名）
 col name for a50
SQL> select file#,name,checkpoint_change# from v$datafile;

     FILE# NAME                                               CHECKPOINT_CHANGE#
---------- -------------------------------------------------- ------------------
         1 /u01/app/oracle/oradata/ORA11GR2/system01.dbf                 1043045
         2 /u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf                 1043045
         3 /u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf                1043045
         4 /u01/app/oracle/oradata/ORA11GR2/users01.dbf                  1043045
         5 /u01/app/oracle/oradata/ORA11GR2/example01.dbf                1043045
         6 /u01/app/oracle/oradata/ORA11GR2/users02.dbf                  1044441
SQL> alter system checkpoint;
select file#,name,checkpoint_change# from v$datafile;
 alter tablespace users offline;
select file#,name,checkpoint_change# from v$datafile;
 alter tablespace users rename datafile '/u01/app/oracle/oradata/ORA11GR2/users01.dbf' to '/home/oracle/dsk1/users01.dbf';
 alter tablespace users rename datafile '/u01/app/oracle/oradata/ORA11GR2/users02.dbf' to '/home/oracle/dsk1/users02.dbf';修改控制文件內容
  select name from v$datafile;
SQL> alter tablespace users online;
總結為四步
1 tablespace offline
2 cp datafile to dest
3 alter tablespace xxx rename
4 tbs online