迁移前尽量把所有连接数据库的应用关掉
1.查看表空间文件地址
select tablespace_name,file_name,online_status
from dba_data_files
where tablespace_name='EAS_D_HLT20220815_STANDARD';
2.将目标表空间设置为脱机状态
alter tablespace EAS_D_HLT20220815_STANDARD offline;
3.确保表空间已脱机
select tablespace_name,file_name,online_status
from dba_data_files
where tablespace_name='EAS_D_HLT20220815_STANDARD';
4.通过linux命令移动或者复制到新的地方
cp /home/oracle/kingdee/EAS_D_HLT20220815_STANDARD.ORA /easdata/inUseData/EAS_D_HLT20220815_STANDARD.ORA
cp /home/oracle/kingdee/EAS_T_HLT20220815_STANDARD.DBF /easdata/inUseData/EAS_T_HLT20220815_STANDARD.DBF
5.修改表空间的数据文件路径
alter tablespace EAS_D_HLT20220815_STANDARD
rename datafile '/home/oracle/kingdee/EAS_D_HLT20220815_STANDARD.ORA'
to '/easdata/inUseData/EAS_D_HLT20220815_STANDARD.ORA';
6.查看修改后表空间的信息
select tablespace_name,file_name,online_status
from dba_data_files
where tablespace_name='EAS_D_HLT20220815_STANDARD';
7.修改表空间为在线状态
alter tablespace EAS_D_HLT20220815_STANDARD online;
8.确认表空间信息是否在线
select tablespace_name,file_name,online_status
from dba_data_files
where tablespace_name='EAS_D_HLT20220815_STANDARD';