An Easy Way to Drop All of the Tables in Your Tablespace in Oracle

Home/Database/An Easy Way to Drop All of the Tables in Your Tablespace in Oracle

run this command:

select 'drop table ', table_name, 'cascade constraints;' from user_tables;

Then copy the output and run that as a sql script.

By | 2017-05-18T15:18:12+00:00 March 8th, 2008|Database|2 Comments

About the Author:

2 Comments

  1. dsfa December 1, 2016 at 8:38 pm - Reply

    Nice

  2. Vincent May 28, 2017 at 9:16 pm - Reply

    This would drop all tables that belongs to user, not just one tablespace

Leave A Comment