Rem drv: <migrate type="data_upgrade" version="10.2.0.1"/>
Rem
Rem $Header: properties_data_upgrade.sql 09-sep-2005.10:54:48 rkpandey Exp $
Rem
Rem properties_data_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      properties_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    rkpandey    09/09/05 - rkpandey_bug-4590005
Rem    rkpandey    09/05/05 - Created
Rem

-- Delete DYNAMICINSTANCE property if INSTANCE is already exists.
-- Update target property to INSTANCE, from DYNAMICINSTANCE.

BEGIN
  DELETE 
    FROM mgmt_target_properties d
   WHERE UPPER(property_type) = 'DYNAMICINSTANCE'
     AND EXISTS(SELECT 1 
                  FROM mgmt_target_properties i
                 WHERE d.target_guid = i.target_guid
                   AND d.property_name = i.property_name
                   AND UPPER(i.property_type) = 'INSTANCE');
             
  UPDATE mgmt_target_properties
     SET property_type = 'INSTANCE'
   WHERE UPPER(property_type) = 'DYNAMICINSTANCE';
  COMMIT;
END;
/