SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/prod/system01.dbf
/u01/app/oracle/oradata/prod/undotbs01.dbf
/u01/app/oracle/oradata/prod/sysaux01.dbf
/u01/app/oracle/oradata/prod/users01.dbf
/u01/app/oracle/oradata/prod/mgmt.dbf
/u01/app/oracle/oradata/prod/mgmt_ecm_depot1.dbf
/u01/test01.dbf
/u01/app/oracle/oradata/prod/catalog01.dbf
在不能关闭数据库的情况下：将表空间offline
alter tablespace USERS offline immediate;
os层面移动好文件后：alter tablespace USERS rename datafile '/u01/app/oracle/oradata/prod/users01.dbf' to '/u01/app/oracle/oradata/prod/users02.dbf'
recover tablespace USERS;
alter tablespace users online;
能关数据库的情况：
启动到mount 状态，
alter database rename file '/u01/app/oracle/oradata/prod/users02.dbf' to '/u01/app/oracle/oradata/prod/users01.dbf
打开数据库即可。
移动online redo
mount状态下
alter database rename file语句
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7969839/viewspace-668598/ ，如需转载，请注明出处，否则将追究法律责任。
