Sometimes, you will have to drop all tables in your Tablespace in the Oracle database. In such cases, here is an easy way to do it.
Run the following command:
select 'drop table ', table_name, 'cascade constraints;' from user_tables;
The above SQL command will return scripts to drop tables existing in your Oracle database tablespace.
Copy the output of the above SQL command as a script and run it.
Doing so will drop all of your tables in your tablespace.
Kuzu Zangpo la! I am Sonam Dargay. I am a full-time software developer. Apart from 9-5 office works, I am a tech enthusiast, blogger, and dreamer.
I graduated from the College of Science and Technology(CST), affiliated with the Royal University of Bhutan.