b1nary0mega
9/25/2015 - 8:42 PM

Create drop statements for all tables and view to dump from tablespace. Just run this code and then copy and paste the output to a sql windo

Create drop statements for all tables and view to dump from tablespace. Just run this code and then copy and paste the output to a sql window and run it! :)

Delete Tables and Views.sql
content_copyfile_download
SELECT 'drop table ', table_name, 'cascade constraints;' FROM user_tables;
SELECT 'drop view ', view_name, 'cascade constraints;' FROM user_views;