Rest assured it will work.
Code:SQL> alter tablespace example offline; Tablespace altered. SQL> !cp /u01/data/ORCL/example01.dbf /u01/data/ORCL/example01a.dbf SQL> alter database rename file '/u01/data/ORCL/example01.dbf' 2 to '/u01/data/ORCL/example01a.dbf'; Database altered. SQL> alter tablespace example online; Tablespace altered. SQL> select tablespace_name, file_name, online_status from dba_data_files; TABLESPACE_NAME FILE_NAME ONLINE_ ------------------ ------------------------------- ------- USERS /u01/data/ORCL/users01.dbf ONLINE UNDOTBS1 /u01/data/ORCL/undotbs01.dbf ONLINE SYSAUX /u01/data/ORCL/sysaux01.dbf ONLINE SYSTEM /u01/data/ORCL/system01.dbf SYSTEM EXAMPLE /u01/data/ORCL/example01a.dbf ONLINE SQL>![]()




Reply With Quote