oracle 10g 怎么彻底删除有数据的表空间后，在重建表空间？

Answer 1

drop tablespace tbsname include contents and datafiles;
然后再重新建立就可以了
create tablespace tbsname datafile '文件路径及文件名' size 500m;

Answer 2

drop tablespace xxxx including contents and datafiles ;
create tablespace xxx datafile '文件路径及文件名' size xxxm;

Answer 3

用这个
drop tablespace xxxx including contents and datafiles

Answer 4

重新建个新的不就完了