--ts_name1:原表空间名
alter tablespace ts_name1 offline; -- windows下需要先 offline
--ts_name2:新表空间名
--F:\Oracle\11gServer\oradata\evoa\ts_name2.dbf:新表空间文件路径
drop tablespace ts_name1 including contents and datafiles;
-- create tablespace ts_name2 datafile 'F:\Oracle\11gServer\oradata\evoa\ts_name2.dbf' size 16M autoextend on next 16M maxsize 1024M;