Rem drv: <migrate type="data_upgrade" version="10.2.0.3" condition="EM_REPOS_MODE=CENTRAL" />
Rem
Rem $Header: upgrade_reports.sql 10-oct-2006.10:29:10 denath Exp $
Rem
Rem upgrade_reports.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      upgrade_reports.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    denath      10/10/06 - Fix bug 5588148. add header condition for GC
Rem                           only.
Rem    denath      09/22/06 - Fix Bug 5455205.Drop report for group.
Rem    denath      09/22/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/10.2.0.3/reports/storage/db_outofbox_storage.sql