spool c:\t.sql;

SELECT 'DROP TABLE '||OWNER||'.'||OBJECT_NAME FROM DBA_OBJECTS WHERE OWNER = 'YYCA' AND OBJECT_TYPE = 'TABLE';

@c:\t.sql;