drop tablespace直接删除文件(转)
create tablespace svn_dir_tree_1
logging
datafile '/data/oracle/product/10.2/db_1/dbs/test_1.dbf'
size 512m
autoextend on
next 512m maxsize 32767M
extent management local;

drop tablespace test including contents;
create tablespace svn_dir_tree_1
logging
datafile '/data/oracle/product/10.2/db_1/dbs/test_1.dbf'
reuse;

drop tablespace test including contents and datafiles;