Rem drv: <migrate type="pre_data_upgrade" version="10.2.0.1" pos="data_propagation_post_creation.sql+"/>
Rem
Rem $Header: provision_post_creation.sql 10-aug-2007.08:07:37 saurgarg Exp $
Rem
Rem provision_post_creation.sql
Rem
Rem Copyright (c) 2005, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      provision_post_creation.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    saurgarg    08/10/07 - Adding registration of purge_prov_collection
Rem    pshroff     08/26/05 - adding repmanager header 
Rem    neearora    08/21/05 - Added a check for callback already exist 
Rem    neearora    07/25/05 - neearora_bug-4500972
Rem    neearora    07/22/05 - Created
Rem

rem
rem Register valid preLoad and postLoad callbacks.
rem
BEGIN
  BEGIN
    MGMT_LOADER.register_pre_load_callback('MGMT_PROVISION.PRELOAD_CALLBACK');
  EXCEPTION WHEN OTHERS THEN
    IF SQLERRM like '%callback already exist%'
      THEN
       NULL;
    ELSE
      RAISE;
    END IF;
  END;
 COMMIT;
END;
/

BEGIN
  BEGIN
    EM_PURGE.add_purge_policy('MGMT_PROV_COLLECTION_PURGE',
                             EM_PURGE.G_POLICY_TYPE_SYSTEM,
                            'MGMT_PROVISION.PURGE_PROV_COLLECTION',
                            24,
                            NULL, -- No rollup procedure
                            'Purge policy for prov collection data',
                            EM_PURGE.G_RETENTION_GROUP_SYSTEM,
                            EM_PURGE.G_POLICY_EXEC_GROUP_DEFAULT,
                            EM_PURGE.G_POLICY_NOT_CONFIGURABLE
                            );
  EXCEPTION WHEN OTHERS THEN
    IF SQLERRM like '%policy already exist%'
      THEN
       NULL;
    ELSE
      RAISE;
    END IF;
  END;
 COMMIT;
END ;
/