set pagesize 0
set lines 300
!rm drop_objectos.sql
spo drop_objectos.sql
select	'DROP ' || object_type || ' ' ||  owner || '.' || object_name || ' cascade constraints;' AS COMANDO
from dba_objects
where owner = 'CCA'
and object_type = 'TABLE'     
order by object_type, object_name;
select	'DROP ' || object_type || ' ' ||  owner || '.' || object_name || ';' AS COMANDO
from dba_objects
where owner = 'CCA'
and object_type in ('FUNCTION','INDEX','LIBRARY','PACKAGE','PROCEDURE','SEQUENCE','TRIGGER','TYPE','VIEW')     
order by object_type, object_name;
spo off
!ls -ltr drop_objectos.sql