SET HEADING OFF
SET FEEDBACK OFF
SET LINESIZE 200
SET PAGESIZE 200

SPOOL DROP_OBJ.LST

select 'DROP '||decode(object_type,'UNDEFINED','MATERIALIZED VIEW',object_type)||' '||object_name||' '||DECODE(OBJECT_TYPE,'TABLE','CASCADE CONSTRAINTS','')||' ;' from user_objects
where object_type in ('TABLE','TRIGGER','VIEW','SEQUENCE','PROCEDURE','PACKAGE','FUNCTION')
order by object_type
/

select 'drop public synonym '||synonym_name||' ;' from all_synonyms
where TABLE_owner='PMEKALA'
/

SPOOL OFF

SET HEADING ON
SET FEEDBACK ON