無法drop tablespace

显示全部楼层 · 2008-2-13 12:43:03

怎么無法drop tablespace ?
SQL> drop tablespace king;
drop tablespace king
*
ERROR at line 1:
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

Elapsed: 00:00:01.09
SQL> drop tablespace roc;
drop tablespace roc
*
ERROR at line 1:
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

Elapsed: 00:00:00.02

千问 · 2008-2-13 12:43:03

看看DBA Guid，看看语法含义。

千问 · 2008-2-13 12:43:03

我把oradata给删了。
现在有什么办法drop 掉这些表空间呢。

千问 · 2008-2-13 12:43:03

alter tablespace king offline;
drop tablespace king;

千问 · 2008-2-13 12:43:03

drop tablespace INCLUDING CONTENTS;
提示里已经写了。

千问 · 2008-2-13 12:43:03

表空间非空加including contents

千问 · 2008-2-13 12:43:03

SQL> drop tablespace king including contents and datafiles;

Tablespace dropped.