Q
Problem solve Get help with specific problems with your technologies, process and projects.

Cannot drop tablespace

I tried to drop a tablespace. This tablespace still shows up in dba_tablespaces.

I tried to drop a tablespace. This tablespace shows up in dba_tablespaces. I cannot drop the tablespace. I receive a message "tablespace xxxxxx does not exist."
Query DBA_TABLESPACES again. This time, note the exact spelling of the tablespace name. Then when issuing the DROP TABLESPACE command, spell the tablespace_name exactly as seen in DBA_TABLESPACE and this time, enclose the tablespace name in double quotes.

Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close