Rem
Rem $Header: basic_tables_schema_upgrade.sql 23-jul-2003.18:25:36 rpinnama Exp $
Rem
Rem basic_tables_schema_upgrade.sql
Rem
Rem Copyright (c) 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      basic_tables_schema_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    rpinnama    07/23/03 - rpinnama_bug-3038103_main
Rem    rpinnama    07/18/03 - Add coll_name and agent_guid columns to metric error tables
Rem    sgrover     05/13/03 - add overflow migration
Rem    sgrover     04/04/03 - sgrover_upgrade_for_perf_fixes
Rem    sgrover     04/04/03 - Created
Rem

ALTER TABLE MGMT_METRICS_RAW INCLUDING value;

ALTER TABLE MGMT_CURRENT_METRICS INCLUDING value;

ALTER TABLE MGMT_METRICS_RAW DROP ("LOAD_TIMESTAMP") CASCADE CONSTRAINTS CHECKPOINT 1024;

ALTER TABLE MGMT_CURRENT_METRICS DROP ("LOAD_TIMESTAMP") CASCADE CONSTRAINTS CHECKPOINT 1024;

ALTER TABLE MGMT_STRING_METRIC_HISTORY DROP ("LOAD_TIMESTAMP") CASCADE CONSTRAINTS CHECKPOINT 1024;

ALTER TABLE MGMT_METRICS_1HOUR DROP ("VALUE_VARIANCE") CASCADE CONSTRAINTS CHECKPOINT 1024;

ALTER TABLE MGMT_METRICS_1DAY DROP ("VALUE_VARIANCE") CASCADE CONSTRAINTS CHECKPOINT 1024;

ALTER TABLE MGMT_METRIC_ERRORS ADD
  (
     coll_name             VARCHAR2(64)    DEFAULT ' ',
     agent_guid            RAW(16)         DEFAULT '00000000000000000000000000000000'
  );

ALTER TABLE MGMT_CURRENT_METRIC_ERRORS ADD
  (
     coll_name             VARCHAR2(64)    DEFAULT ' ',
     agent_guid            RAW(16)         DEFAULT '00000000000000000000000000000000'
  );


Rem Upgrade basic Indexes 
ALTER TABLE MGMT_METRIC_ERRORS
   DROP CONSTRAINT MGMT_METRIC_ERRORS_PK;

ALTER TABLE MGMT_METRIC_ERRORS
   ADD CONSTRAINT MGMT_METRIC_ERRORS_PK
       PRIMARY KEY (target_guid, metric_guid, coll_name, agent_guid, collection_timestamp)
       USING INDEX INITRANS 4;

ALTER TABLE MGMT_CURRENT_METRIC_ERRORS
   DROP CONSTRAINT MGMT_CURRENT_METRIC_ERRORS_PK;

ALTER TABLE MGMT_CURRENT_METRIC_ERRORS
   ADD CONSTRAINT MGMT_CURRENT_METRIC_ERRORS_PK
       PRIMARY KEY (target_guid, metric_guid, coll_name, agent_guid )
       USING INDEX INITRANS 4;