http://www.dba-oracle.com/t_move_tablespaces_datafiles_filesystems.htm
Oracle: move tablespace datafile between filesystems
Oracle Tips by Burleson Consulting
Question:
My Oracle data file is out of room in the filesystem. df -kt shows oracle is 92% full. How do I relocate the datafile and tablespace to another file system?
Answer:
When you run out of space in a filesystem you have two choices:
- Increase the size of the filesystem
- Move the datafile to another filesystem on a separate mount point
If you want to move the tablespace you need to:
1 - Quiecse the tablespace (alter tablespace dba_temp_files offline)
2 - Copy the data file to the new location
3 - Rename the tablespace datafile "alter tablespace dba_temp_files
rename datafile /oracle/temp2 to /oraclenew/temp2"
4 - Bring the tablespace online (alter tablespace dba_tamp_files online;
5 - Nuke the old file from the fileysystem (rm temp2)