Home » RDBMS Server » Server Administration » dropping lower case tablespace (Release 11.1.0.7.0)
dropping lower case tablespace [message #531920] Fri, 18 November 2011 09:32 Go to next message
BeefStu
Messages: 192
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


Re: dropping lower case tablespace [message #531922 is a reply to message #531920] Fri, 18 November 2011 09:33 Go to previous messageGo to next message
BlackSwan
Messages: 23134
Registered: January 2009
Senior Member
drop tablespace "test" including contents and datafiles;
Re: dropping lower case tablespace [message #531923 is a reply to message #531922] Fri, 18 November 2011 09:35 Go to previous message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
thanks
Previous Topic: Fractured block during buffer read
Next Topic: Need White paper or asset on Oracle
Goto Forum:
  


Current Time: Thu Dec 18 06:06:50 CST 2014

Total time taken to generate the page: 0.11202 seconds