Moving Oracle Datafiles...non system and system

To move non-system oracle datafiles

1. alter tablespace offline;
2. host out and move the files
3. alter database rename file 'fully_qualified_old_file_name' to 'fully_qualified_new_file_name';
4. alter tablespace online;
5. Backup your controlfile.

To move system oracle datafiles

1. SQL> shutdown immediate;
2. SQL> startup mount;
3. SQL> !ls -l ;
4. SQL> !mv ;
5. SQL> alter database rename file '' to '';
SQL> alter database open;