Rem
Rem $Header: drop_wb_rt_ht_audit.sql 27-nov-2007.10:24:59 tzrose Exp $
Rem
Rem drop_wb_rt_ht_audit.sql
Rem
Rem Copyright (c) 2007, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      drop_wb_rt_ht_audit.sql - remove runtime audit data definitions
Rem
Rem    DESCRIPTION
Rem      This script is used to remove runtime audit tables and indexes
Rem      from a heterogeneous environment using a DB2 database
Rem
Rem    NOTES
Rem      Logon to the DB2 database used for the Audit Data Source
Rem      db2 -t -vf <OWB-HOME>/owb/rtasst/jrtaudit/db2/drop_wb_rt_ht_audit.sql
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    tzrose      10/10/07 - Created to be compatible for DB2
Rem

DROP TABLE wb_rt_ht_audit_msg;
DROP TABLE wb_rt_ht_audit_param;
DROP TABLE wb_rt_ht_audit_file;
DROP TABLE wb_rt_ht_audit_trace;
DROP TABLE wb_rt_ht_audit_error_source;
DROP TABLE wb_rt_ht_audit_error;
DROP TABLE wb_rt_ht_audit_struct;
DROP TABLE wb_rt_ht_audit_step;
DROP TABLE wb_rt_ht_audit_task;
DROP TABLE wb_rt_ht_audit_phase;
DROP TABLE wb_rt_ht_audit_job;
DROP TABLE wb_rt_ht_audit_sequence;