Rem drv: <migrate type="schema_downgrade" version="10.1.0.4"/>
Rem
Rem $Header: storage_schema_downgrade.sql 19-jul-2005.13:22:01 chyu Exp $
Rem
Rem storage_schema_downgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      storage_schema_downgrade.sql - downgrade storage reporting schema 
Rem        from 10.2
Rem
Rem    DESCRIPTION
Rem      downgrade storage reporting schema from 10.2 
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    chyu        07/19/05 - modifying the new rep manager header 
Rem    ajdsouza    04/07/05 - ajdsouza_stg_bug4277089_fix
Rem    ajdsouza    03/31/05 - Created
Rem

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

-- Drop schema in the reverse order of creation

-- INDICES
-- Drop indexes from storage_ui_indexes
DROP INDEX mgmt_storage_ui_target_idx1;

-- Drop indexes from storage_common_indexes

-- TABLES
-- Drop tables from storage_ui_tables
DROP TABLE mgmt_storage_report_ui_targets;

-- Drop tables from storage_common_tables
DROP TABLE "MGMT_STORAGE_REPORT_DATA";
DROP TABLE "MGMT_STORAGE_REPORT_KEYS";
DROP TABLE "MGMT_STORAGE_REPORT_ISSUES";
DROP TABLE "MGMT_STORAGE_REPORT_ALIAS";

-- TYPES
-- Drop types from storage_ui_types.sql
DROP TYPE target_metric_table;
DROP TYPE storage_varchar2_table;
DROP TYPE storage_number_table;
DROP TYPE storage_timeseries_rec_list;
DROP TYPE storage_timeseries_rec;
DROP context storage_context;

-- Drop types from storage_common_types.sql