oracle删除DBF文件

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文件即可。