Moving Control Files in Oracle

1. SQL> alter system set control_files='new_file1_location','new_file2_location','new_file3_location' scope=spfile;
2. SQL> shutdown immediate;
3. move/copy control files to new location
4. SQL> startup

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;