Rem drv: <create type="post_creation" pos="rep_metric/rep_metric_post_creation.sql-"/>
Rem
Rem $Header: purge_post_creation.sql 14-jul-2005.03:05:10 gsbhatia Exp $
Rem
Rem purge_post_creation.sql
Rem
Rem Copyright (c) 2003, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      purge_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    scgrover    07/07/05 - add extended sql trace 
Rem    gsbhatia    07/03/05 - New repmgr header impl 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    rpinnama    09/08/03 - rpinnama_purge_policies 
Rem    rpinnama    09/07/03 - Created
Rem

BEGIN
  mgmt_log.register_logging_module (EM_PURGE.PURGE_POLICY_MODULE, 
				    EM_PURGE.PURGE_POLICY_DISP_NAME,
				    'EM_PURGE.APPLY_PURGE_POLICIES()');
  COMMIT;
END;
/

Rem 
Rem Create predefined purge policy groups
Rem
BEGIN

  EM_PURGE.add_purge_policy_group(EM_PURGE.G_RETENTION_GROUP_DETAILED,
                                  'Detailed Data Group', 24);
  EM_PURGE.add_purge_policy_group(EM_PURGE.G_RETENTION_GROUP_LVL1_SUMMARY,
                                  'Level 1 Summarized Data Group', 7*24);
  EM_PURGE.add_purge_policy_group(EM_PURGE.G_RETENTION_GROUP_LVL2_SUMMARY,
                                  'Level 2 Summarized Data Group', 31*24);
  EM_PURGE.add_purge_policy_group(EM_PURGE.G_RETENTION_GROUP_ALERTS,
                                  'Alert Data Group', 180*24);
  EM_PURGE.add_purge_policy_group(EM_PURGE.G_RETENTION_GROUP_CONFIG,
                                  'Configuration Data Group', 366*24);
  EM_PURGE.add_purge_policy_group(EM_PURGE.G_RETENTION_GROUP_JOB_HISTORY,
                                  'Job History Data Group',   180*24);
  EM_PURGE.add_purge_policy_group(EM_PURGE.G_RETENTION_GROUP_SYSTEM,
                                  'System Data Group',        7*24);
  commit;
END;
/

@@&&EM_SQL_ROOT/core/v102020/purge_data_upgrade.sql