1.offline表空间
ALTER TABLESPACE FHMES OFFLINE TEMPORARY;
2.重名数据文件
ALTER DATABASE RENAME FILE 'C:\app\OracleHomeUser\oradata\EBR12CR2\FHMESD.DBF' TO 'E:\ORACLE_HOME\datafile\FHMESD.DBF';
3.online表空间
ALTER TABLESPACE FHMES ONLINE;
4.recover datafile
alter database recover datafile X;