A tablespace has been created in the database through a script using Mixed case.Now we want to drop the tablespace.

We are unable to drop the tablespace even if it is available. The reason is while creating the tablespace the name was specified in mixed case within double quotes as follows


To drop the tablespace mention the tablespace name within double quotes as shown below.

Now the tablespace stands dropped.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn:

Anuradha’s LinkedIn:

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.