Rem Copyright (c) 2007, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      drop_wb_rv_public_audit_views.sql - remove public audit view definitions
Rem
Rem    DESCRIPTION
Rem      This script is used to remove public audit 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/drop_wb_rv_public_audit_views.sql
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    tzrose      01/15/08 - Created to be compatible for OWBSYS in Oracle
Rem

drop view ALL_RV_AUDIT_MSG;
drop view ALL_RV_AUDIT_PARAMETERS;
drop view ALL_RV_AUDIT_STEP_RUN_TRACE; 
drop view ALL_RV_AUDIT_EXEC_FILES;
drop view ALL_RV_AUDIT_RUN_ERROR_SOURCES;
drop view ALL_RV_AUDIT_RUN_ERRORS;
drop view ALL_RV_STEP_STRUCTS;
drop view ALL_RV_STEP_EXECUTIONS;
drop view ALL_RV_TASK_EXECUTIONS;
drop view ALL_RV_PHASE_EXECUTIONS;
drop view ALL_RV_JOB_EXECUTIONS;