Rem Copyright (c) 2007, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      rab_deinstall.sql - remove Runtime Audit Browser view definitions
Rem
Rem    DESCRIPTION
Rem      This script is used to remove Runtime Audit Browser tables and views
Rem      for a heterogeneous environment using OWBSYS in an Oracle database
Rem
Rem    NOTES
Rem      Logon to the Oracle database to be used for the Audit Data Source
Rem      @<OWB-HOME>/owb/rtasst/jrtaudit/owbsys/rab_deinstall.sql
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    tzrose      01/15/07 - Created to be compatible for OWBSYS in Oracle
Rem

DROP VIEW uab_rt_stores;
DROP VIEW uab_rt_execution_stores;
DROP VIEW uab_rt_exec_process;
DROP VIEW uab_rt_exec_process_runs;
DROP VIEW uab_rt_exec_proc_hier;
DROP VIEW uab_rt_exec_proc_run_counts;
DROP VIEW uab_rt_exec_proc_run_metrics;
DROP VIEW uab_rt_exec_proc_run_params;
DROP VIEW uab_rt_exec_process_run_errors;
DROP VIEW uab_rt_execution_messages;
DROP VIEW uab_rt_exec_act_run_errors;
DROP VIEW uab_rt_exec_act_results;
DROP VIEW uab_rt_exec_act_run_sources;
DROP VIEW uab_rt_exec_act_run_targets;
DROP VIEW uab_rt_exec_act_step_sources;
DROP VIEW uab_rt_exec_act_step_targets;
DROP VIEW uab_rt_exec_act_step_structs;
DROP VIEW uab_rt_exec_act_steps;
DROP VIEW uab_rt_exec_act_run_params;
DROP VIEW uab_rt_exec_act_run_traces;

DROP VIEW HAB_RT_EXEC_ERROR_SOURCES;
DROP VIEW HAB_RT_EXEC_ACT_RUN_TRACES;
DROP VIEW HAB_RT_EXEC_ACT_RUN_PARAMS;
DROP VIEW HAB_RT_EXEC_ACT_STEPS;
DROP VIEW HAB_RT_EXEC_ACT_STEP_STRUCTS;
DROP VIEW HAB_RT_EXEC_ACT_STEP_TARGETS;
DROP VIEW HAB_RT_EXEC_ACT_STEP_SOURCES;
DROP VIEW HAB_RT_EXEC_ACT_RUN_TARGETS;
DROP VIEW HAB_RT_EXEC_ACT_RUN_SOURCES;
DROP VIEW HAB_RT_EXEC_ACT_RESULTS;
DROP VIEW HAB_RT_EXECUTION_FILES;
DROP VIEW HAB_RT_STORES;
DROP VIEW HAB_RT_EXECUTION_STORES;
DROP VIEW HAB_RT_EXEC_PROC_RUN_PARAMS;
DROP VIEW HAB_RT_EXECUTION_MESSAGES;
DROP VIEW HAB_RT_EXEC_ACT_RUN_ERRORS;
DROP VIEW HAB_RT_EXEC_PROCESS_RUN_ERRORS;
DROP VIEW HAB_RT_EXEC_PROC_RUN_METRICS;
DROP VIEW HAB_RT_EXEC_PROC_RUN_COUNTS;
DROP VIEW HAB_RT_EXEC_PROCESS_RUNS;
DROP VIEW HAB_RT_EXEC_PROC_HIER;
DROP VIEW HAB_RT_EXEC_PROCESS;
DROP TABLE WB_RT_CONSTANTS_TABLE;