Rem
Rem drv: <migrate type= "data_upgrade" version= "10.2.0.2"/>
Rem $Header: swlib_data_upgrade.sql 14-dec-2005.03:58:39 kashukla Exp $
Rem
Rem swlib_data_upgrade.sql 
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      swlib_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    kashukla    12/14/05 - moving version from 10.2.0.1 to 10.2.0.2 
Rem    gauragup    11/20/05 - sql updates 
Rem    gauragup    11/20/05 - sql updates 
Rem    gauragup    11/20/05 - Created
Rem

BEGIN

UPDATE MGMT_SWLIB_DIRECTORIES SET  DESCRIPTION=NULL WHERE NAME='COMP_Components' AND PARENT_ID IS NULL;
UPDATE MGMT_SWLIB_DIRECTORIES SET  DESCRIPTION=NULL WHERE NAME='COMP_Directives' AND PARENT_ID IS NULL;
UPDATE MGMT_SWLIB_DIRECTORIES SET  DESCRIPTION=NULL WHERE NAME='COMP_Networks' AND PARENT_ID IS NULL;
UPDATE MGMT_SWLIB_DIRECTORIES SET  DESCRIPTION=NULL WHERE NAME='COMP_Images' AND PARENT_ID IS NULL;
UPDATE MGMT_SWLIB_DIRECTORIES SET  DESCRIPTION=NULL WHERE NAME='COMP_Suites' AND PARENT_ID IS NULL;

COMMIT;

END;
/