Rem drv: <migrate type="schema_downgrade" version="10.1.0.4"/>
Rem
Rem $Header: data_propagation_schema_downgrade.sql 19-jul-2005.13:22:00 chyu Exp $
Rem
Rem data_propagation_schema_upgrade.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      data_propagation_schema_downgrade.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       chyu     07/19/05 - modifying the new rep manager header 
Rem       rzazueta 06/20/05 - Drop index on mgmt_update_operations_details 
Rem       rzazueta 05/10/05 - rzazueta_bug-4268941
Rem       rzazueta 05/04/05 - drop columns from operations_details table
Rem       skini    03/15/05 - skini_bug-4187366
Rem

DROP TABLE MGMT_UPDATE_COLL_CREDS_DATA;
DROP TABLE MGMT_UPDATE_TEMPLATE_DATA_MAP;

ALTER TABLE MGMT_UPDATE_OPERATION MODIFY (job_owner VARCHAR2(32));

ALTER TABLE MGMT_UPDATE_OPERATIONS_DETAILS 
DROP(
     last_updated_timestamp,
     error_message
);

DROP INDEX MGMT_UPDATE_OPS_DETAILS_IDX01;
DROP INDEX MGMT_UPDATE_OPS_DETAILS_IDX02;
DROP INDEX MGMT_UPDATE_OPS_DETAILS_IDX03;