Rem drv: <migrate type= "schema_upgrade" version= "10.2.0.1"/>
Rem
Rem $Header: notification_schema_upgrade.sql 11-aug-2005.17:59:36 dcawley Exp $
Rem
Rem notification_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      notification_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    dcawley     08/11/05 - dcawley_bug-4549769
Rem    dcawley     08/11/05 - Change header 
Rem    dcawley     08/11/05 - Created
Rem

-- A new field called occurred has been added to the job object so
-- drop the dependent object and recreate both of them
DROP TYPE MGMT_NOTIFY_CORRECTIVE_ACTION;

CREATE OR REPLACE TYPE MGMT_NOTIFY_JOB UNDER MGMT_NOTIFY_OBJECT
(job_name              VARCHAR2(128),
 job_owner             VARCHAR2(256),
 job_type              VARCHAR2(32),
 job_status            NUMBER,
 occurred              DATE,
 state_change_guid     RAW(16),
 job_guid              RAW(16),
 execution_id          RAW(16),
 targets               SMP_EMD_NVPAIR_ARRAY
) NOT FINAL;
/

CREATE OR REPLACE TYPE MGMT_NOTIFY_CORRECTIVE_ACTION UNDER MGMT_NOTIFY_JOB
(metric_name           VARCHAR2(256),
 metric_column         VARCHAR2(64),
 metric_value          VARCHAR2(1024),
 severity_code         NUMBER,
 key_value_name        VARCHAR2(512),
 key_value             VARCHAR2(1290),
 key_value_guid        VARCHAR2(256),
 ctxt_list             MGMT_NOTIFY_COLUMNS
);
/

CREATE OR REPLACE TYPE MGMT_NOTIFY_JOB_SC AS OBJECT
(
   job_name VARCHAR2(64),
   job_type VARCHAR2(32),
   job_type_nlsid VARCHAR2(64),
   job_owner VARCHAR2(256),
   target_names MGMT_MEDIUM_STRING_ARRAY,
   target_types MGMT_MEDIUM_STRING_ARRAY,
   target_timezone VARCHAR2(64),
   logged DATE,
   occurred DATE,
   status NUMBER(2),
   job_id RAW(16),
   execution_id RAW(16),
   step_id NUMBER(38),
   label VARCHAR2(256),
   label_nlsid VARCHAR2(256),
   metric_name VARCHAR2(256),
   metric_column VARCHAR2(64),
   metric_value VARCHAR2(1024),
   violation_level NUMBER,
   keys MGMT_NOTIFY_COLUMNS,
   ctxt_list MGMT_NOTIFY_COLUMNS
);
/