REM // Drop database objects used by the Trace Formatter

set feedback off
set heading off

rem // Drop the event data tables.  Since these tables are created
rem // dynamically by the formatter, we need to get the names of the
rem // tables from table event.  We'll create file otrcftmp.sql to
rem // contain a drop statement for each table, and then execute it.

spool otrcfmtd.tmp
select unique 'drop table '||event_table_name||';' from epc_event;
spool off
@otrcfmtd.tmp

drop table epc_process;
drop table epc_facility;
drop table epc_event;
drop table epc_item;
drop table epc_event_item;
drop table epc_facility_registration;
drop table epc_collection;
drop sequence epc_collection_id;
