WYJ on orcdb >SELECT FILE_NAME,TABLESPACE_NAME FROM dba_data_files

FILE_NAME TABLESPACE_NAME
------------------------------------------------------------ ------------------------------
F:ORACLEPRODUCT10.2.0ORADATAORCDBMYUNDOA.DBF MYUNDO
F:ORACLEPRODUCT10.2.0ORADATAORCDBEXAMPLE01.DBF EXAMPLE
F:ORACLEPRODUCT10.2.0ORADATAORCDBUSERS01.DBF USERS
F:ORACLEPRODUCT10.2.0ORADATAORCDBSYSAUX01.DBF SYSAUX
F:ORACLEPRODUCT10.2.0ORADATAORCDBSYSTEM01.DBF SYSTEM
F:ORACLEPRODUCT10.2.0ORADATAORCDBA01.DBF WYJ
F:ORACLEPRODUCT10.2.0ORADATAORCDBBIGTBS.DBF BIGTBS
F:ORACLEPRODUCT10.2.0ORADATAORCDBUNDOTBS2A.DBF UNDOTBS2已选择8行。

WYJ on orcdb > alter database datafile 'F:ORACLEPRODUCT10.2.0ORADATAORCDBA01.DBF' offline;数据库已更改。

WYJ on orcdb > alter database rename datafile
2 'F:ORACLEPRODUCT10.2.0ORADATAORCDBA01.DBF'
3 to 'F:ORACLEPRODUCT10.2.0ORADATAORCDBWYJA.DBF';
alter database rename datafile
*第 1 行出现错误:
ORA-02231: ALTER DATABASE 选项缺失或无效


WYJ on orcdb > ALTER DATABASE RENAME FILE
2 'F:ORACLEPRODUCT10.2.0ORADATAORCDBA01.DBF'
3 to 'F:ORACLEPRODUCT10.2.0ORADATAORCDBWYJA.DBF';数据库已更改。

WYJ on orcdb > conn sys/sys@orcdb as sysdba已连接。
SYS on orcdb > shutdown immediate数据库已经关闭。已经卸载数据库。
ORACLE 例程已经关闭。
SYS on orcdb > startup mount
ORACLE 例程已经启动。

Total System Global Area 524288000 bytes
Fixed Size 1249968 bytes
Variable Size 251661648 bytes
Database Buffers 268435456 bytes
Redo Buffers 2940928 bytes数据库装载完毕。
SYS on orcdb > recover datafile 'F:ORACLEPRODUCT10.2.0ORADATAORCDBWYJA.DBF';完成介质恢复。
SYS on orcdb > alter database open;数据库已更改。

SYS on orcdb > select file_name,tablespace_name from dba_data_files;

FILE_NAME TABLESPACE_NAME
------------------------------------------------------------ ------------------------------
F:ORACLEPRODUCT10.2.0ORADATAORCDBMYUNDOA.DBF MYUNDO
F:ORACLEPRODUCT10.2.0ORADATAORCDBEXAMPLE01.DBF EXAMPLE
F:ORACLEPRODUCT10.2.0ORADATAORCDBUSERS01.DBF USERS
F:ORACLEPRODUCT10.2.0ORADATAORCDBSYSAUX01.DBF SYSAUX
F:ORACLEPRODUCT10.2.0ORADATAORCDBSYSTEM01.DBF SYSTEM
F:ORACLEPRODUCT10.2.0ORADATAORCDBWYJA.DBF WYJ
F:ORACLEPRODUCT10.2.0ORADATAORCDBBIGTBS.DBF BIGTBS
F:ORACLEPRODUCT10.2.0ORADATAORCDBUNDOTBS2A.DBF UNDOTBS2已选择8行。