Ram K. answered 07/16/19
SQL | Oracle | Calculus | Algebra
If you don't have system level access, and want to scrub your schema, the following sql will produce a series of drop statements, which can then be executed.
select 'drop '||object_type||' '|| object_name|| DECODE(OBJECT_TYPE,'TABLE',' CASCADE CONSTRAINTS','') || ';' from user_objects
purge recyclebin;