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.
Site Network: Personal | Professional | Photography
This blog will contain content related to Java, Seam, Security, my sites and projects, as well as other technical subjects I am interested in.
Comments and questions are welcome!
run this command:
SELECT 'drop table ', table_name, 'cascade constraints;' FROM user_tables;
Then copy the output and run that as a sql script.