Move datafile to different location - ORACLE

From time to time a DBA might need move an Oracle database datafile from one location to another. Reasons for this might include: I/O balancing for performance reasons, or to rectify incorrect naming standards.


http://www.orafaq.com/wiki/Move_datafile_to_different_location

More about tablespaces:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/physical.htm

Books:

http://www.oracle.com/pls/db102/portal.all_books

http://www.oracle.com/pls/db111/portal.all_books