To delete the datafiles associated with a tablespace at the same time that the tablespace is dropped, use the INCLUDING CONTENTS AND DATAFILES clause. The following statement drops the users tablespace and its associated datafiles:DROP TABLESPACE users INCLUDING CONTENTS AND DATAFILES;
drop tablespace i3_orcl including contents; 删除表空间及数据文件
只用DROP的话,不会同时删除OS文件。一般来说都是另外单独删除的,同时删的话就没机会恢复了。
tgm78(shop34161266.taobao.com) 是否应该改成drop tablespace i3_orcl including contents and datafiles;
tablespace is dropped, use the INCLUDING CONTENTS AND DATAFILES clause.
The following statement drops the users tablespace and its associated datafiles:DROP TABLESPACE users INCLUDING CONTENTS AND DATAFILES;
删除表空间及数据文件