Steps to move Oracle datafiles to another file system

• Take the tablespace offline

If you want to know in wich tablespace a datafile belong

select TABLESPACE_NAME from dba_data_files where FILE_NAME = 'file_name';

To take a tablespace offline

alter tablespace tablespace_name offline

• Physicaly move the datafiles at OS level

mv 'old_file_name' 'new_file_name' (on Linux / Unix)

• Rename the datafiles at database level

alter tablespace tablespace_name rename datafile 'old_datafile_name' to 'new_data_file_name';

• Bring the tablespace back online

alter tablespace tablespace_name online;