1 The status of the data file is set to offline state
Table space set to offline
Sql> select File_name,tablespace_name from Dba_data_files;
Sql> alter tablespace users offline;
Sql> select Name,status from V$datafile;
NAME STATUS
-------------------------------------------------- -------
/U01/APP/ORACLE/ORADATA/ORA11GR2/SYSTEM01.DBF SYSTEM
/U01/APP/ORACLE/ORADATA/ORA11GR2/SYSAUX01.DBF ONLINE
/U01/APP/ORACLE/ORADATA/ORA11GR2/UNDOTBS01.DBF ONLINE
/U01/APP/ORACLE/ORADATA/ORA11GR2/USERS01.DBF OFFLINE
/U01/APP/ORACLE/ORADATA/ORA11GR2/EXAMPLE01.DBF ONLINE
2 operating system level to complete the real renaming operation
3 database level modify data file name
Alter DATABASE rename file '/u01/app/oracle/oradata/ora11gr2/users01.dbf ' to '/u01/app/oracle/oradata/ora11gr2/ USERS01.DBF.BK ';
4 table space Reset to online status
Alter tablespace users online;
Sql> select Name,status from V$datafile;
Change the data file name or path