Rem drv: <migrate type="schema_downgrade" version="10.2.0.3" />
Rem
Rem $Header: bam_schema_downgrade.sql 14-nov-2006.15:11:43 skkunise Exp $
Rem
Rem bam_schema_downgrade.sql
Rem
Rem Copyright (c) 2006, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      bam_schema_downgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    skkunise    11/14/06 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

-- Drop schema in the reverse order of creation

Rem
Rem Drop all indexes
Rem
DROP INDEX MGMT_BAM_DATA_ISESSIONS_IDX_02;
DROP INDEX MGMT_BAM_DATA_ISESSIONS_IDX_02'
DROP INDEX MGMT_BAM_DATA_ISESSIONS_IDX_01;
DROP INDEX MGMT_BAM_OS_STATUS_IDX_01;
DROP INDEX MGMT_BAM_OS_METRICS_IDX_01;
DROP INDEX MGMT_BAM_OS_ALERTS_IDX_01;
DROP INDEX MGMT_BAM_DATA_OSESSIONS_IDX_02;
DROP INDEX MGMT_BAM_DATA_OSESSIONS_IDX_01;
DROP INDEX MGMT_BAM_DATA_HUBS_IDX_01;

Rem
Rem Drop all tables
Rem
DROP TABLE MGMT_BAM_ISESSION_DIAG;
DROP TABLE MGMT_BAM_ISESSION_KPIS;
DROP TABLE MGMT_BAM_ISESSION_DATASOURCE;
DROP TABLE MGMT_BAM_DATA_ISESSIONS;
DROP TABLE MGMT_BAM_OSESSION_STATUS;
DROP TABLE MGMT_BAM_OSESSION_METRICS;
DROP TABLE MGMT_BAM_OSESSION_ALERTS;
DROP TABLE MGMT_BAM_OSESSION_DIAG;
DROP TABLE MGMT_BAM_DATA_OSESSIONS;
DROP TABLE MGMT_BAM_DATA_HUBS;