Rem
Rem $Header: rac_data_downgrade_11000.sql 16-jan-2007.16:49:02 sadattaw Exp $
Rem
Rem rac_data_downgrade_11000.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      rac_data_downgrade_11000.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    sadattaw    01/16/07 - data downgrade script for racdb
Rem    sadattaw    01/16/07 - Created
Rem

--------------------------------------------
-- Un Registering metadata Cluster Managaged Services for target type cluster and snapshot type mgmt_rac_services
--------------------------------------------
  -- Remove all related metadatas
  DELETE FROM MGMT_ECM_SNAPSHOT_MD_TABLES WHERE METADATA_ID IN (SELECT METADATA_ID FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'cluster' AND SNAPSHOT_TYPE = 'mgmt_rac_services');
  DELETE FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'cluster' AND SNAPSHOT_TYPE = 'mgmt_rac_services';

COMMIT;