How do I relocate the datafile and tablespace to another file system?

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)