Rem drv: <migrate type="data_upgrade" version="10.2.0.4"/>
Rem
Rem $Header: ecm_data_upgrade.sql 02-jan-2008.16:56:38 rrawat Exp $
Rem
Rem ecm_data_upgrade.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ecm_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     rrawat     09/25/06 - Bug-5546644
Rem

update MGMT_ECM_SNAPSHOT_MD_COLUMNS
set HISTORY_ON = 'N'
where  NAME = 'TIMESTAMP'
and TABLE_NAME = 'ECM$HIST_INV_COMPONENTS';

update MGMT_ECM_SNAPSHOT_MD_COLUMNS
set HISTORY_ON = 'N'
where NAME = 'INSTALLATION_DATE'
and TABLE_NAME = 'MGMT_ECM_OS_REGISTERED_SW';

update MGMT_ECM_SNAPSHOT_MD_COLUMNS
set HISTORY_ON = 'N'
where NAME = 'INSTALLATION_DATE'
and TABLE_NAME = 'ECM$HIST_OS_COMPONENTS';

update MGMT_ECM_SNAPSHOT_MD_COLUMNS
set HISTORY_ON = 'N'
where  NAME = 'TIMESTAMP'
and TABLE_NAME = 'ECM$HIST_INV_PATCHSETS';

update MGMT_ECM_SNAPSHOT_MD_COLUMNS
set HISTORY_ON = 'N'
where  NAME = 'TIMESTAMP'
and TABLE_NAME = 'ECM$HIST_INV_PATCHES';

commit;

-- Update materialized views
  BEGIN ECM_UTIL.UPDATE_ECM_METADATA; END;
/