set pagesize 00;
set heading off;
set feedback off;
spool drop_tables.lis
select 'drop table '||table_name ||';' from
  USER_tables;
spool off;
set feedback on;
@drop_tables.lis
/
set pagesize 00;
set heading off;
set feedback off;
spool drop_index.lis
select 'drop index '||index_name ||';' from
  user_indexes;
spool off;
set feedback on;
@drop_index.lis
/
set pagesize 00;
set heading off;
set feedback off;
spool drop_sqs.lis
select 'drop sequence '||sequence_name ||';' from
  user_sequences;
spool off;
set feedback on;
@drop_sqs.lis
/
set pagesize 00;
set heading off;
set feedback off;
spool drop_sys.lis
select 'drop public synonym '||synonym_name ||';' from
  all_synonyms where table_owner='CAL_CALIBRATION';
spool off;
set feedback on;
@drop_sys.lis
/





