oracle表空间问题

Question

明明 有date表空间
为何不能修改和删除？
SQL> SELECT TABLESPACE_NAME FROM DBA_TABLESPACES;TABLESPACE_NAME                                                                 
------------------------------                                                  
SYSTEM                                                                          
UNDOTBS                                                                         
CWMLITE                                                                         
DRSYS                                                                           
EXAMPLE                                                                         
INDX                                                                            
TEMP                                                                            
TOOLS                                                                           
USERS                                                                           
OEM_REPOSITORY                                                                  
DATE                                                                            已选择11行。SQL> ALTER TABLESPACE DATE OFFLINE FOR RECOVER;
ALTER TABLESPACE DATE OFFLINE FOR RECOVER
                 *
ERROR 位于第 1 行: 
ORA-02140: 无效的表空间名称 
SQL> SPOOL OFF;
先谢谢了

Answer 1

试试加上空间所属用户：如 "USER"."DATE"

Answer 2

名字上面加上双引号。
ALTER   TABLESPACE  "DATE"   OFFLINE   FOR   RECOVER;