Clear Oracle Schema

/* This will produce a list of sql statements to drop table from the current schema. Copy the statments for the tables you wish to drop then execute that set of "drop Table" over and over until the all have errors, which indicates they have all been dropped. */ purge recyclebin; select * from cat; select 'drop table ' || table_name || ';' from cat where table_type='TABLE';