当前的表空间如下：
SQL> select name from v$tablespace; NAME
--------------------------------------------------------------------------------
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
tb01
tb02
删除表空间，报错如下
SQL> drop tablespace tb01 including contents and datafiles;
drop tablespace tb01 including contents and datafiles
*
ERROR at line 1:
ORA-00959: tablespace 'TB01' does not exist
原因：建立表空间的时候，使用了小写名称
解决办法：因此删除时候必须加上双引号
SQL> drop tablespace "tb01" including contents and datafiles; Tablespace dropped.