Rem drv: <migrate type="schema_downgrade" version="10.1.0.4"/>
Rem
Rem $Header: admin_schema_downgrade.sql 19-jul-2005.13:21:58 chyu Exp $
Rem
Rem admin_schema_downgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      admin_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/19/05 - modifying the new rep manager header 
Rem    edemembe    02/09/05 - edemembe_bug-3556656
Rem    edemembe    02/09/05 - Created
Rem

Rem
Rem Make sure the CBO stats for the "big" 3 schema tables are unlocked during downgrade.
Rem
BEGIN
  EXECUTE IMMEDIATE 
    'call dbms_stats.unlock_table_stats(''SYSMAN'', ''MGMT_METRICS_RAW'')';
  EXECUTE IMMEDIATE 
    'call dbms_stats.unlock_table_stats(''SYSMAN'', ''MGMT_METRICS_1HOUR'')';
  EXECUTE IMMEDIATE 
    'call dbms_stats.unlock_table_stats(''SYSMAN'', ''MGMT_METRICS_1DAY'')';
EXCEPTION
    WHEN OTHERS THEN
      NULL;  -- Ignore errors
END;