曾经以为把所有的表清空drop掉后其文件已经删除,但实质DBF数据文件依然还存在,在ORADATA文件下。必须要这样删除
1
2
3
4
5
6
7
8
9
|
DROP
TABLESPACE tablespace_name
[ including contents [
and
datafiles ] [
CASCADE
CONSTRAINT
] ];
无选项
-- 当表空间为空才能删除;
including contents — 删除表空间及对象;
including contents
and
datafiles — 删除表空间、对象及数据文件;
includingcontents
CASCADE
CONSTRAINT
— 删除关联;
including contents
and
datafiles
cascade
constraint
-- 含前两项。
DROP
TABLESPACE see including contents
and
datafiles
cascade
constraint
;
|
然后在关闭oracle服务,手动删除该DBF文件即可。