Tablespace and Tablespace Management

Common use of tablespace is performance related. You can place tables into a tablespace that sits on datafiles residing on one set of disk drives and placing indexes for those tables into another tablespace that sits on datafiles residing on different disk drives. This reduces disk contention that might otherwise occur on heavily accessed tables.

Reference: Sybex Oracle 10g Admin I Study Guide

more

Rename datafile in Tablespace:

select name,status from v$datafile;

alter tablespace TEST offline;

alter tablespace TEST rename datafile '/database/test1/files/test01.dbf'
to '/database/test1/files/test02.dbf';

alter tablespace TEST online;

Other commands:

select file_name,status from dba_data_files;

http://www.md.chalmers.se/Support/Software/Databases/server.901/a90117/dfiles.htm#7527

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