Rem drv: <migrate type="schema_downgrade" version="10.2.0.0" pos="-"/>
Rem
Rem $Header: db_comp_schema_downgrade.sql 30-oct-2006.11:50:17 xshen Exp $
Rem
Rem db_comp_schema_downgrade.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      db_comp_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    xshen       10/30/06 - bug 5622689
Rem    chyu        07/13/05 - chyu_new_repmgr_upg_db
Rem    chyu        07/12/05 - Created
Rem

Rem
Rem    SCHAUDHR        04/10/04 
Rem


DROP TABLE "MGMT_DIROBJ_USERS_HOTLIST" CASCADE CONSTRAINTS;


Rem
Rem    PBANTIS        04/10/05 
Rem

-- Oracle Backup tables.
DROP TABLE MGMT_OB_ADMIN_CLIENT_DB;
DROP TABLE MGMT_OB_ADMIN_HOSTS;

-- configuration 
ALTER TABLE MGMT_HA_BACKUP
    DROP("SESSION_KEY",
    "SESSION_RECID",
    "SESSION_STAMP",
    "COMMAND_ID",
    "START_TIME",
    "TIME_TAKEN_DISPLAY",
    "INPUT_TYPE",
    "OUTPUT_DEVICE_TYPE",
    "INPUT_BYTES_DISPLAY",
    "OUTPUT_BYTES_DISPLAY",
    "OUTPUT_BYTES_PER_SEC_DISPLAY");


-- Drop the 10gR2 Backup and Recovery tables.
DROP TABLE MGMT_RCVCAT_CONFIG;
DROP TABLE MGMT_RCVCAT_REPOS;


  -- Create the 10gR1 Backup and Recovery tables.
  -- Table for storing list of database targets registered.

-- THIS WAS MOVED TO DATA area, due to dependency problems


Rem
Rem    YSUN        04/10/06 
Rem


DROP TABLE "MGMT_HA_CLS_INTR_CONN";
DROP TABLE "MGMT_HA_RAC_INTR_CONN";
DROP VIEW "MGMT$INTERFACE_STATS";
DROP VIEW "MGMT$RACDB_INTERCONNECTS";
DROP VIEW "MGMT$CLUSTER_INTERCONNECTS";

Rem 
Rem XSHEN - Fixing bug 5622689.
Rem 

DROP VIEW "MGMT_V_DB_DATAFILES_ECM"; 
DROP VIEW "MGMT_V_DB_REDOLOGS_ECM";
DROP VIEW "MGMT_V_DB_CONTROLFILES_ECM";
DROP VIEW "MGMT_V_DB_DBNINSTANCEINFO_ECM";
DROP VIEW "MGMT_V_DB_TABLESPACES_ECM";


Rem
Rem    RREILLY        04/10/06 
Rem


-- OSM Disk Group Policy Table
DROP TABLE "MGMT_OSM_DISK_GROUP_ECM" CASCADE CONSTRAINTS;

-- Replace OSM Type withe 10.1.0.3 version
create or replace type SMP_EMD_OSMSITEMAP_OBJ as OBJECT (
    TYPE_DISPLAY_NAME     VARCHAR2(256),
    LAST_UPDATED_TIME     VARCHAR2(4000),
    CURRENT_STATUS        INTEGER,
    AVAIL_PCT             NUMBER,
    START_TIMESTAMP       Date,
    INSTANCE_NAME         VARCHAR2(4000),
    INSTANCE_STARTTIME    VARCHAR2(4000),
    INSTANCE_VERSION      VARCHAR2(4000),
    ALERTLOG_TIMESTAMP    VARCHAR2(64),
    ALERTLOG_SEVERITY     NUMBER,
    HOST_NAME             VARCHAR2(64),    
    TARGET_GUID           VARCHAR2(32)
);
/