Rem drv: <migrate type="data_upgrade" version="10.2.0.1"/>
Rem
Rem $Header: assoc_data_upgrade.sql 17-aug-2005.23:44:07 pmodi Exp $
Rem
Rem assoc_data_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      assoc_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    pmodi       08/17/05 - Bug:4552476 Use procedure for upgrading data 
Rem    chyu        07/18/05 - adding the upgrade header 
Rem    pmodi       07/14/05 - pmodi_bug-4486836
Rem    pmodi       07/12/05 - Created
Rem

-- Code for updating assoc count has been moved from v102010/assoc_data_upgrade
-- to v102020/assoc_data_upgrade for beta to production upgrade
--recreate flat assoc entry

-- Truncat table mgmt_flat_target_assoc as we are
-- repopulating it in next script
TRUNCATE TABLE mgmt_flat_target_assoc ;

--recreate flat assoc entry
EXEC EM_ASSOC.recreate_full_flat_assoc;


COMMIT;