Rem drv: <migrate type="data_upgrade" version="10.2.0.0" pos="webapp/webapp_data_upgrade.sql+"/>
Rem
Rem $Header: trace_data_upgrade.sql 26-jul-2005.19:41:16 chyu Exp $
Rem
Rem trace_data_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      trace_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    chyu        07/26/05 - modifying the migrate header position 
Rem    chyu        07/18/05 - updating the new rep manager header 
Rem    jsadras     03/04/05 - purge policy 
Rem    rpinnama    02/06/05 - rpinnama_add_upgrade_scripts
Rem    rpinnama    02/04/05 - Created
Rem

prompt Inserting seed data
BEGIN
    emdw_log.create_context('DEFAULT') ;
    emdw_log.create_context('TRACER') ;
    emdw_log.create_context('LOADER') ;
    emdw_log.create_context('NOTIFICATION') ;
    emdw_log.create_context('REPOCOLLECTION') ;
    emdw_log.create_context(MGMT_BLACKOUT_ENGINE.MODULE_NAME);
    COMMIT ;
END ;
/

BEGIN
  EM_PURGE.add_purge_policy('EMDW_TRACE',
                             EM_PURGE.G_POLICY_TYPE_SYSTEM,
                            'EMDW_LOG.PURGE',
                            24,
                            NULL, -- No rollup procedure
                            'Purge policy for trace data',
                            EM_PURGE.G_RETENTION_GROUP_SYSTEM,
                            EM_PURGE.G_POLICY_EXEC_GROUP_DEFAULT,
                            EM_PURGE.G_POLICY_NOT_CONFIGURABLE
                            );
END ;
/