表空间名字大小写问题

woodwalker

1、Create tablespace "student"
   logging
   Datafile '/u01/app/oracle/oradata/temp/student.dbf' size 2M
   Extent management local segment space
   Management auto;
２、
SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
ADMIN
TEACHER
student
３、

SQL>  alter tablespace student rename to dd;
alter tablespace student rename to dd
*
ERROR at line 1:
ORA-00959: tablespace 'STUDENT' does not exist


SQL> alter tablespace STUDENT rename to dd;
alter tablespace STUDENT rename to dd
*
ERROR at line 1:
ORA-00959: tablespace 'STUDENT' does not exist


SQL> alter tablespace 'student' rename to student;
alter tablespace 'student' rename to student
                 *
ERROR at line 1:
ORA-02140: invalid tablespace name

－－－－－
这个怎么办，建表空间的时候用了双引号加小写，然后我现在想改名改不了，
不仅如此，表也删不掉，也用不了。。。

woodwalker

哦...加双引号就行了...呵呵

renxiao2003

因为你的STUDENT加了双引号，所以后续对它的操作都要加上双引号。