Rem drv: <migrate type="schema_downgrade" version="10.2.0.0"/>
Rem
Rem $Header: config_schema_downgrade.sql 12-jul-2005.11:40:46 chyu Exp $
Rem
Rem config_schema_downgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      config_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    chyu        07/12/05 - adding the new rep manager upgrade header 
Rem    rreilly     02/24/05 - remove controlfiles_size and dbrollup
Rem    xshen       02/04/05 - xshen_bug-4160666
Rem    xshen       02/04/05 - Created
Rem

DROP TABLE "MGMT_DB_OPTIONS_ECM";

ALTER TABLE "MGMT_DB_CONTROLFILES_ECM"
    DROP ("OS_STORAGE_ENTITY");

ALTER TABLE "MGMT_DB_REDOLOGS_ECM"
    DROP ("OS_STORAGE_ENTITY",
          "THREAD_NUM");

ALTER TABLE "MGMT_DB_DATAFILES_ECM"
    DROP ("OS_STORAGE_ENTITY");

ALTER TABLE "MGMT_DB_TABLESPACES_ECM"
    DROP ("TABLESPACE_USED_SIZE",
          "SEGMENT_SPACE_MANAGEMENT",
          "BLOCK_SIZE",
          "MIN_EXTENTS",
          "MIN_EXTLEN",
          "BIGFILE");

ALTER TABLE "MGMT_DB_DBNINSTANCEINFO_ECM"
    DROP ("DEFAULT_TEMP_TABLESPACE", 
	  "CHARACTERSET",
	  "NATIONAL_CHARACTERSET");

COMMIT;