------------------------------------------------------------
-- This is the same file as oracle_cell_ecm_deploy_drop.sql with the drop table
-- and view scripts removed.
------------------------------------------------------------
DECLARE
  records_purged INTEGER ; 
BEGIN

---------------------------------------------------------
 --Purging of History and Compare Results 
---------------------------------------------------------

 --------------purge History ----------- 
  BEGIN 
   records_purged := MGMT_DELTA.PURGE_HISTORY ( 0, 'CELL_Config', 'oracle_cell',  NULL);
   COMMIT;
  END ; 

 ------------- purge Compare Results ----------- 
  BEGIN 
   DELETE FROM MGMT_DELTA_SAVED_COMPARISON 
    WHERE TARGET_TYPE = 'oracle_cell'
      AND COMPARISON_TYPE = 'CELL_Config';
   COMMIT;
  END ; 
---------------------------------------------------------

  -- 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 = 'oracle_cell' AND SNAPSHOT_TYPE = 'CELL_Config');
  DELETE FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'oracle_cell' AND SNAPSHOT_TYPE = 'CELL_Config';


 --------------purge Saved Configurations ----------- 
  BEGIN 
   DELETE MGMT_ECM_GEN_SNAPSHOT 
    WHERE TARGET_TYPE = 'oracle_cell'
      AND SNAPSHOT_TYPE = 'CELL_Config'
      AND IS_CURRENT = 'N' ; 
   COMMIT;
  END;
-----------------------------------------------------

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

END;
/