Rem
Rem $Header: rac_schema_downgrade_11000.sql 12-dec-2007.18:23:44 sadattaw Exp $
Rem
Rem rac_schema_downgrade_11000.sql
Rem
Rem Copyright (c) 2007, 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      rac_schema_downgrade_11000.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    dchakumk    03/10/08 - XbranchMerge dchakumk_6752_xbmsrc from
Rem                           st_emdbsa_11.1
Rem    sadattaw    12/12/07 - 
Rem    shasingh    08/09/07 - XbranchMerge
Rem                           shasingh_11g_19509a_targets_discovery from main 
Rem    ajdsouza    02/16/07 - downgrade for types for mgmt$interface_stats view
Rem    rsamaved    02/02/07 - drop types created for sql queries
Rem    sadattaw    01/16/07 - schema downgrade script for racdb
Rem    sadattaw    01/16/07 - Created
Rem


Rem
Rem CLUSTER STATUS TYPES
Rem
DROP TYPE mgmt_cluster_status_table
/
DROP TYPE mgmt_cluster_status_object
/
DROP TYPE mgmt_cluster_collection_table
/
DROP TYPE mgmt_cluster_collection_object
/



Rem
Rem Services types
Rem

DROP TABLE MGMT_RAC_SERVICES;

DROP TABLE MGMT_CONFIG_ACTIVITIES;

DROP TYPE MGMT_PROBLEM_SERV_ARRAY_TYPE;
DROP TYPE MGMT_PROBLEM_SERV_INFO_TYPE;

DROP TYPE MGMT_SERV_ALERT_ARRAY_TYPE;
DROP TYPE MGMT_SERV_ALERT_INFO_TYPE;

DROP TYPE MGMT_SERV_PERF_INFO_ARRAY_TYPE ;
DROP TYPE MGMT_SERV_PERF_INFO_TYPE ;

Rem
Rem  mgmt$interface_stats view types
Rem

DROP TYPE mgmt_racdb_iface_stats_table
/
DROP TYPE mgmt_racdb_interface_stats
/
DROP TYPE mgmt_racdb_tb_metric_table
/
DROP TYPE mgmt_racdb_tb_metric
/
DROP TYPE mgmt_racdb_icstat_table
/
DROP TYPE mgmt_racdb_icstat
/
DROP TYPE mgmt_racdb_ic_table
/
DROP TYPE mgmt_racdb_ic
/
DROP TYPE mgmt_cls_ic_table
/
DROP TYPE mgmt_cls_ic
/
DROP TYPE mgmt_cls_host_ic_table
/
DROP TYPE mgmt_cls_host_ic
/
DROP TYPE mgmt_cls_member_table
/
DROP TYPE mgmt_cls_member
/