##下线表空间
SQL>alter tablespace DB_1104_JSWXYX_O1 offline;
##查看表空间文件路径
SQL>select t1.name,t2.name
from v
t
a
b
l
e
s
p
a
c
e
t
1
,
v
tablespace t1,v
tablespacet1,vdatafile t2
where t1.ts# = t2.ts# AND t1.name=‘DB_1104_JSWXYX_O1’;
下线表空间
SQL> alter tablespace DB_1104_JSWXYX_O1 offline;
复制数据文件到新的目录
cp /data/oracle/oradata/orcl/DB_1104_JSWXYX_O1.DBF /home/test_directory/DB_1104_JSWXYX_O1.DBF
rename修改表空间
SQL> alter tablespace cifdb rename datafile ‘/u01/app/oracle/oradata/cifdb.dbf’ to ‘/u01/app/oracle/oradata/CIFDB/cifdb.dbf’;
online表空间
SQL> alter tablespace DB_1104_JSWXYX_O1 online;
检查数据文件
SQL>select t1.name,t2.name
from v
t
a
b
l
e
s
p
a
c
e
t
1
,
v
tablespace t1,v
tablespacet1,vdatafile t2
where t1.ts# = t2.ts# AND t1.name=‘DB_1104_JSWXYX_O1’;