DBAD: Script to drop everything from a schema

Warning !!! BE CAREFUL! – THIS DROPS EVERYTHING UNDER THE LOGON/OWNER THAT RUNS IT

 Akismet Anti-Spam
Activate | Delete
Used by millions, Akismet is quite possibly the best way in the world to protect your blog from spam. It keeps your site protected even while you sleep. To get started: activate the Akismet plugin and then go to your Akismet Settings page to set up your API key.
Version 4.1.1 | By Automattic | View details
Select All In One SEO Pack
All In One SEO Pack
Activate | Delete
Out-of-the-box SEO for your WordPress blog. Features like XML Sitemaps, SEO for custom post types, SEO for blogs or business sites, SEO for ecommerce sites, and much more. More than 50 million downloads since 2007.
Version 2.12 | By Michael Torbert | View details
Select All-in-One WP Migration
All-in-One WP Migration
Activate | Delete
Migration tool for all your blog data. Import or Export your blog content with a single click.
Version 6.91 | By ServMask | View details
Select BackUp WD
BackUp WD
Activate | Delete
Backup WD is an easy-to-use, fully functional backup plugin that allows to backup your website.
SET SERVEROUTPUT ON SIZE 1000000
BEGIN
FOR cur_rec IN (SELECT object_name, object_type
FROM user_objects
WHERE object_type IN ('TABLE','SYNONYM','VIEW', 'PACKAGE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE', 'TYPE')) LOOP
BEGIN
IF cur_rec.object_type = 'TABLE' THEN
EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '" CASCADE CONSTRAINTS';
ELSE
EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '"';
END IF;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line('FAILED: DROP ' || cur_rec.object_type || ' "' || cur_rec.object_name || '"');
END;
END LOOP;
END;
/
 
PURGE RECYCLEBIN;
SET ERRORLOGGING OFF