SQL> host ls -l /opt/oracle/product/10.2.0/oradata/wangxiaoqi/
total 6115528
-rw-r----- 1 oracle oinstall 1073750016 Jul 28 01:35 owb_tbs01.dbf
-rw-r----- 1 oracle oinstall 26222592 Jul 28 01:35 recover_tbs.dbf
-rw-r----- 1 oracle oinstall 209723392 Jul 28 01:35 stream_tbs01.dbf
-rw-r----- 1 oracle oinstall 471867392 Jul 28 16:05 sysaux01.dbf
-rw-r----- 1 oracle oinstall 566239232 Jul 28 16:08 system01.dbf
-rw-r----- 1 oracle oinstall 31465472 Jul 27 22:00 temp01.dbf
-rw-r----- 1 oracle oinstall 513810432 Jul 28 16:10 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Jul 28 10:14 users01.dbf
-rw-r----- 1 oracle oinstall 1056768 Jul 28 16:08 wxq_tbs2.dbf
SQL> alter database rename file '/opt/oracle/product/10.2.0/oradata/wangxiaoqi/wxq_tbs.dbf' to '/opt/oracle/product/10.2.0/oradata/wangxiaoqi/wxq_tbs2.dbf';
Database altered.
SQL> alter database datafile '/opt/oracle/product/10.2.0/oradata/wangxiaoqi/wxq_tbs2.dbf' online;
Database altered.
SQL> alter tablespace wxq_tbs2 read write;
Tablespace altered.
SQL> select tablespace_name,file_name,status from dba_data_files;
TABLESPACE_N FILE_NAME STATUS
------------ ------------------------------------------------------------------ ------------------
USERS /opt/oracle/product/10.2.0/oradata/wangxiaoqi/users01.dbf AVAILABLE
SYSAUX /opt/oracle/product/10.2.0/oradata/wangxiaoqi/sysaux01.dbf AVAILABLE
UNDOTBS1 /opt/oracle/product/10.2.0/oradata/wangxiaoqi/undotbs01.dbf AVAILABLE
SYSTEM /opt/oracle/product/10.2.0/oradata/wangxiaoqi/system01.dbf AVAILABLE
OWB_TBS /opt/oracle/product/10.2.0/oradata/wangxiaoqi/owb_tbs01.dbf AVAILABLE
RECOVERY_TBS /opt/oracle/product/10.2.0/oradata/wangxiaoqi/recover_tbs.dbf AVAILABLE
STREAM_TBS /opt/oracle/product/10.2.0/oradata/wangxiaoqi/stream_tbs01.dbf AVAILABLE
WXQ_TBS2 /opt/oracle/product/10.2.0/oradata/wangxiaoqi/wxq_tbs2.dbf AVAILABLE
8 rows selected.
至此，就全部修改完成了。再强调一下，只有在10g中才能够修改，10g以前是不可以的。
作者 sjmz30071360