oracle mv tablespace

SQL> select name from v$datafile;

NAME

/u01/oracle/oradata/yoon/system01.dbf
/u01/oracle/oradata/yoon/sysaux01.dbf
/u01/oracle/oradata/yoon/undotbs01.dbf
/u01/oracle/oradata/yoon/users01.dbf

2.修改表空间为offline：
SQL> alter tablespace users offline;
Tablespace altered.

3.拷贝数据文件
[[email protected] yoon]$ cp users01.dbf /u01/oracle/oradata/yoondata/
mv users01.dbf /u01/oracle/oradata/yoondata/ – 移动表空间数据

4.修改表空间存储路径
SQL> alter tablespace users rename datafile ‘/u01/oracle/oradata/yoon/users01.dbf’ to ‘/u01/oracle/oradata/yoondata/users01.dbf’;
Tablespace altered.

5.修改表空间为online
SQL> alter tablespace users online;
Tablespace altered.