Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't drop tablespace with white space on tablespace name

Wander(Brazil)Sep 17 2008 — edited Sep 17 2008

Hi all,

can anybody help me ?

I have a tablespace with a white space in its name and I need drop it and I having a little problem.

Follow the sentece:

SQL> select 'drop tablespace "'||tablespace_name||'" including contents and datafiles;' from dba_tablespaces where tablespace_name like '%TS_MTS_DADOS_PRO%';

'DROPTABLESPACE_NAME"'||TABLESPACE_NAME||'"INCLUDINGCONTENTSANDDATAFILES;'
--------------------------------------------------------------------------------
drop tablespace "TS_MTS_DADOS_PRO " including contents and datafiles;

SQL> drop tablespace "TS_MTS_DADOS_PRO " including contents and datafiles;
drop tablespace "TS_MTS_DADOS_PRO " including contents and datafiles
*
ERRO na linha 1:
ORA-00959: tablespace 'TS_MTS_DADOS_PRO ' does not exist

Oracle database: 10.2.0.4
S. Operational: Win 2003 32 Bits.

Thanks.

Wander (Brazil)

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2008

Added on Sep 17 2008

#general-database-discussions

17 comments

1,039 views