Rem drv: <migrate type="data_upgrade" version="10.2.0.3"/>
Rem    
Rem $Header: policy_data_upgrade.sql 27-jul-2006.04:32:30 niramach Exp $
Rem    
Rem policy_data_upgrade.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      policy_data_upgrade.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    niramach    07/27/06 - Backport niramach_bug-5331253 from main 
Rem    denath      07/03/06 - Fix 4770372.sql changed for count. 
Rem    denath      06/26/06 - fix bug4770372.drop purge policy for 
Rem                           MGMT_POLICY_ERRORS. 

SET ECHO ON

Rem Upgrade script for Bug 4770372.

DECLARE
    ptype NUMBER;
BEGIN
    SELECT count(*)  
    INTO   ptype 
    FROM   MGMT_PURGE_POLICY
    WHERE  policy_name = 'MGMT_POLICY_ERRORS';
  
    IF ptype = 1 THEN
       EM_PURGE.drop_purge_policy('MGMT_POLICY_ERRORS');
    END IF;

    COMMIT;

EXCEPTION
    WHEN OTHERS THEN
       DBMS_OUTPUT.PUT_LINE('***** INFO : Error droping purge policy MGMT_POLICY_ERRORS');
       NULL;

END;

/

@&EM_SQL_ROOT/core/10.2.0.3/policy/reports/policy_outofbox_reports.sql