-- dropping all CERA tables for test purpose

-- dropLOAD logged into dropLOAD.lst
@dropLOAD.sql

-- logging into dropALL.lst
spool dropALL

-- dropping
@dropDATA_ACC.sql
@dropDATA_ORG.sql
@dropCERA.sql

-- proving the massacre
select synonym_name  from user_synonyms;
select sequence_name from user_sequences;
select table_name    from user_tables;

spool off
