dropping lower case tablespace [message #531920] |
Fri, 18 November 2011 09:32 |
|
BeefStu
Messages: 208 Registered: October 2011
|
Senior Member |
|
|
How can I drop a lower case tablespace name from my DB?
SQL> select * from v$version;
BANNER
------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
select tablespace_name, dump(tablespace_name) from dba_tablespaces
TABLESPACE_NAME
------------------------------
DUMP(TABLESPACE_NAME)
---------------------------------------------------------------
test
Typ=1 Len=4: 116,101,115,116
SQL> show user;
USER is "SYS"
SQL> drop tablespace test including contents and datafiles;
drop tablespace test including contents and datafiles
*
ERROR at line 1:
ORA-00959: tablespace 'TEST' does not exist
SQL> drop tablespace 'test' including contents and datafiles;
drop tablespace 'test' including contents and datafiles
*
ERROR at line 1:
ORA-02216: tablespace name expected
SQL> drop tablespace TEST including contents and datafiles;
drop tablespace TEST including contents and datafiles
*
ERROR at line 1:
ORA-00959: tablespace 'TEST' does not exist
|
|
|
|
|