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