select tablespace_name,
file_name,
bytes,
status
from dba_data_files
where tablespace_name ='SYSTEM';
2.使用dba权限的用户登录数据库服务器,并关闭数据库
conn sys/lianhc-123 as sysdba
shutdown immediate
cp
/opt/oracle/app/oradata/orcl/system01.dbf /opt/oracle/app/oradata/orcl/tablespace/system01.dbf
startup mount
alter database renamefile'/opt/oracle/app/oradata/orcl/system01.dbf'
to '/opt/oracle/app/oradata/orcl/tablespace/system01.dbf';
alter database open;select tablespace_name,
file_name,
status
from dba_data_files
where tablespace_name ='SYSTEM';
3.迁移非系统表空间
alter tablespace MANAGER_TBS1 offline;hostcp'/opt/oracle/app/oradata/orcl/managertbs01.dbf''/opt/oracle/app/oradata/orcl/tablespace/managertbs01.dbf'
alter database renamefile'/opt/oracle/app/oradata/orcl/managertbs01.dbf'
to '/opt/oracle/app/oradata/orcl/tablespace/managertbs01.dbf';
alter tablespace MANAGER_TBS1 online;select tablespace_name,
file_name,
status
from dba_data_files
where tablespace_name ='MANAGER_TBS1';