Rem
Rem $Header: emcore/source/oracle/sysman/emdrep/sql/core/12.1.0.2/notification/em_notification_types_upgrade.sql rbali_oneoff_updated/1 2025/03/14 06:41:13 rbali Exp $
Rem
Rem em_notification_types_upgrade.sql
Rem
Rem Copyright (c) 2012, 2025, Oracle and/or its affiliates. 
Rem All rights reserved.

Rem BEGIN EMRU_FILE_METADATA
Rem EMRU_SOURCE_FILE:emcore/source/oracle/sysman/emdrep/sql/core/12.1.0.2/notification/em_notification_types_upgrade.sql
Rem EMRU_UNIX_DELIVERABLES:
Rem emcore/source/oracle/sysman/emdrep/sql/core/12.1.0.2/notification/em_notification_types_upgrade.sql

Rem EMRU_FILE_POSTINSTALL:<!!! enter the view based location of the executable file. If there is NONE leave as-is !!!>
Rem EMRU_GENERIC_FLAG:NONE
Rem END EMRU_FILE_METADATA

Rem
Rem    NAME
Rem      em_notification_types_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    gbafna      01/07/25 - make synonyms noneditionable
Rem    rnadidar    02/11/15 - cut over to EBR
Rem    jianpeng    04/27/12 - bug13357390 add repeat and duration annotation
Rem    jianpeng    03/20/12 - Created, bug 12918824, 12890282
Rem

DROP TYPE EM_NOTIF_PLSQL_10G_MSG FORCE;

ALTER TYPE EM_NOTIF_SUBSCRIBER_OBJ MODIFY ATTRIBUTE RULE_SET_NAME VARCHAR2(256) CASCADE;
ALTER TYPE EM_NOTIF_SUBSCRIBER_OBJ MODIFY ATTRIBUTE RULE_NAME VARCHAR2(256) CASCADE;
ALTER TYPE EM_NOTIF_ADV_DEVICE_OBJ MODIFY ATTRIBUTE RULE_SET_NAME VARCHAR2(256) CASCADE;
ALTER TYPE EM_NOTIF_ADV_DEVICE_OBJ MODIFY ATTRIBUTE RULE_NAME VARCHAR2(256) CASCADE;

ALTER SESSION SET CURRENT_SCHEMA=SYSMAN_TYPES;

ALTER TYPE EM_NOTIF_DELIVERY_PAYLOAD MODIFY ATTRIBUTE RULESET_NAME VARCHAR2(256) CASCADE;
ALTER TYPE EM_NOTIF_DELIVERY_PAYLOAD MODIFY ATTRIBUTE RULE_NAME VARCHAR2(256) CASCADE;


ALTER TYPE EM_NOTIF_DELIVERY_PAYLOAD ADD ATTRIBUTE (
         DURATION_VALUE NUMBER
      ) CASCADE;

create or replace noneditionable synonym SYSMAN.EM_NOTIF_DELIVERY_PAYLOAD for EM_NOTIF_DELIVERY_PAYLOAD;

 

ALTER SESSION SET CURRENT_SCHEMA=SYSMAN;

