对于非system表空间
可以在数据库open状态下操作
SQL>alter tablespace RB_DATA offline;
SQL>alter tablespace RB_DATA rename datafile '/soft/u01/app/oracle/oradata/ENSEMBLE/rb_data01.dbf' to '/app/cjfat/oradata/ENSEMBLE/rb_data01.dbf';
[oracle@dbserver ~]$ mv /soft/u01/app/oracle/oradata/ENSEMBLE/rb_data01.dbf /app/cjfat/oradata/ENSEMBLE/
SQL>alter tablespace RB_DATA online;
对于系统表空间只能在mount下进行
SQL>shutdown immediate;
SQL>startup mount
必须先移文件
[oracle@dbserver ~]$ mv /soft/u01/app/oracle/oradata/ENSEMBLE/system01.dbf /app/cjfat/oradata/ENSEMBLE/
SQL>alter database rename file '/soft/u01/app/oracle/oradata/ENSEMBLE/system01.dbf' to '/app/cjfat/oradata/ENSEMBLE/system01.dbf';
SQL>alter database open;
注意两种修改表空间的方法
alter tablespace方法必须要在数据库处于open状态下才能执行