Rem drv: <migrate type="data_upgrade" version="11.0.0.0" condition="EM_REPOS_MODE=CENTRAL"/>
Rem
Rem $Header: reports_upgrade_gc.sql 06-oct-2006.09:04:14 mnihalan Exp $
Rem
Rem reports_upgrade_gc.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      reports_upgrade_gc.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    mnihalan      10/06/06 - Change version to 11.0.0.0
Rem    mnihalan      10/06/06 - Created
Rem

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

BEGIN

  mgmt_ip.delete_report_by_title(
    report_owner_in => 'SYSMAN',
    report_title_in => 'DBMSG_DATABASE_GROUP_SPACE_USAGE',
    check_security  => 0 );
  mgmt_ip.deregister_sql_statement(
    p_name => 'oracle.sysman.db.storage.reports.DBGroupCurrDBSpcUsage');
  mgmt_ip.deregister_sql_statement(
    p_name => 'oracle.sysman.db.storage.reports.DBGroupHistStorageChartSql');
  mgmt_ip.deregister_sql_statement(
    p_name => 'oracle.sysman.db.storage.reports.DBGroupTbspAllocUsage');
  mgmt_ip.deregister_sql_statement(
    p_name => 'oracle.sysman.db.storage.reports.CurrDBGroupTbspFullAlertSummary');
  mgmt_ip.deregister_sql_statement(
    p_name => 'oracle.sysman.db.storage.reports.DBGroupFullAlertCount');
  COMMIT;


END;
/

-- Run Reports create scripts.
@&EM_SQL_ROOT/db/11.0.0.0/reports/db_outofbox_storage_gc.sql