Rem drv: <migrate type="pre_data_upgrade" version="10.2.0.1" pos="website/website_post_creation.sql+"/>
Rem
Rem $Header: gensvc_post_creation.sql 20-sep-2005.09:47:59 mfidanbo Exp $
Rem
Rem gensvc_post_creation.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      gensvc_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    mfidanbo    09/20/05 - fix upgrade break 
Rem    mfidanbo    09/16/05 - convert the response, usage metric to 
Rem                           keys_from_mult_colls = 1 
Rem    chyu        07/25/05 - modifying the upgrade header 
Rem    chyu        07/18/05 - adding the upgrade header 
Rem    rmarripa    07/15/05 - rmarripa_bug-4438024
Rem    rmarripa    07/12/05 - Created
Rem

-- Perfrom common gensvc init
@@&&EM_SQL_ROOT/core/v102020/gensvc/gensvc_common_init.sql


BEGIN

  UPDATE MGMT_METRICS SET KEYS_FROM_MULT_COLLS = 1
   WHERE target_type IN (MGMT_GLOBAL.G_GENERIC_SERVICE_TYPE ,
                         MGMT_GLOBAL.G_WEBSITE_TARGET_TYPE ,
                         MGMT_GLOBAL.G_AGGREGATE_SERVICE_TYPE)
     AND metric_name IN (MGMT_SERVICE.G_USAGE_METRIC_NAME, 
                         MGMT_SERVICE.G_PERFORMANCE_METRIC_NAME);

END;

/
show errors;