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      from a heterogeneous environment using an Oracle database
Rem
Rem    NOTES
Rem      Logon to the Oracle database used for the Audit Data Source
Rem      @<OWB-HOME>/owb/rtasst/jrtaudit/oracle/rab_deinstall.sql
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    tzrose      01/15/07 - Created to be compatible for 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 RAB_RT_EXEC_ERROR_SOURCES;
DROP VIEW RAB_RT_EXEC_ACT_RUN_TRACES;
DROP VIEW RAB_RT_EXEC_ACT_RUN_PARAMS;
DROP VIEW RAB_RT_EXEC_ACT_STEPS;
DROP VIEW RAB_RT_EXEC_ACT_STEP_STRUCTS;
DROP VIEW RAB_RT_EXEC_ACT_STEP_TARGETS;
DROP VIEW RAB_RT_EXEC_ACT_STEP_SOURCES;
DROP VIEW RAB_RT_EXEC_ACT_RUN_TARGETS;
DROP VIEW RAB_RT_EXEC_ACT_RUN_SOURCES;
DROP VIEW RAB_RT_EXEC_ACT_RESULTS;
DROP TABLE WB_RT_DEF_OPERATOR_RESULTS;
DROP VIEW RAB_RT_EXECUTION_FILES;
DROP VIEW RAB_RT_AUDIT_LOCATION_PARAMS;
DROP TABLE RAB_RT_FILE_TYPES;
DROP TABLE WB_RTV_STORES;
DROP VIEW WB_RTV_EXECUTION_STORES;
DROP VIEW RAB_RT_EXEC_PARAM_VALUES;
DROP VIEW RAB_RT_EXEC_PROC_RUN_PARAMS;
DROP VIEW RAB_RT_EXECUTION_MESSAGES;
DROP VIEW RAB_RT_EXEC_ACT_RUN_ERRORS;
DROP VIEW RAB_RT_EXEC_PROCESS_RUN_ERRORS;
DROP VIEW RAB_RT_EXEC_PROC_RUN_METRICS;
DROP VIEW RAB_RT_EXEC_PROC_RUN_COUNTS;
DROP VIEW RAB_RT_EXEC_PROCESS_RUNS;
DROP VIEW RAB_RT_EXEC_PROC_HIER;
DROP VIEW RAB_RT_EXEC_PROCESS;
DROP TABLE WB_RT_CONSTANTS_TABLE;
DROP TABLE RAB_RT_WH_OBJECTS;
DROP TABLE RAB_RT_REP_TYPES;
DROP TABLE RAB_RT_EXTERNAL_URLS;
DROP TABLE RAB_RT_EXCEPTION_CHECKS;
DROP TABLE RAB_RT_SOURCE_TARGET;
DROP TABLE RAB_RT_EXEC_SEVERITY;
DROP TABLE RAB_RT_EXEC_PROC_STATUS;
DROP TABLE RAB_RT_EXEC_PROC_RESULTS;
DROP TABLE RAB_RT_DEP_SEVERITY;
DROP TABLE RAB_RT_AUDIT_OBJECTS;
DROP VIEW RAB_RT_INSTALLATIONS;
DROP VIEW ALL_RT_INSTALLATIONS;