Drop all from schema owner

Drop all from schema owner SQL code www.2cto.com -- To drop all user objects under a schemad set heading off; set feedback off; set echo on; set serveroutput off; set termout off; spool drop_all_objects. SQL select CASE object_type WHEN 'table' then'drop' | object_type | ''| object_name | 'cascade CONSTRAINTS PURGE; 'when' view'then'drop' | object_type | ''| object_name | 'cascade CONSTRAINTS; 'else' drop' | object_type | ''| object_name | '; 'End as "-- text" from user_objects where object_name not like '% BIN $ %' and object_type not in ('package body', 'table partition', 'index ', 'Index partition') order by object_type, object_name; spool off; set echo on feedback on spool drop_all.log @ drop_all_objects. SQL spool off/purge recyclebin/CREATE OR REPLACE TYPE BULK_LOAD_OBJ AS OBJECT (generic_key varchar2 (200 )) /create or replace type bulk_load_ntt as table of bulk_load_obj/create or replace TYPE "RECORD_KEY_VARRAY" as varray (1000) OF VARCHAR2 (100);/quit