最近一台Windows 环境的Oracle测试机D盘满了,想把D盘的Oracle物理表空间文件转移到E盘中。操作如下:
cmd命令行sqlplus登陆Oracle数据库,按顺序执行(REALTYARCHIVES_RUNNING物理表空间名称,REALTYARCHIVES_RUNNING.DBF物理表空间文件):
1、alter tablespace REALTYARCHIVES_RUNNING offline;
2、host move D:\OraDataFile\DataFile\REALTYARCHIVES_RUNNING.DBF E:\OraDataFile\DataFile\
3、alter tablespace REALTYARCHIVES_RUNNING rename datafile 'D:\OraDataFile\DataFile\REALTYARCHIVES_RUNNING.DBF' to 'E:\OraDataFile\DataFile\REALTYARCHIVES_RUNNING.DBF';
4、alter tablespace REALTYARCHIVES_RUNNING online;