DROP TABLE OMALERT.OM_ALERT_PARAMETERS CASCADE CONSTRAINTS ;
/
CREATE TABLE OMALERT.OM_ALERT_PARAMETERS (
  PARAM_ID     NUMBER (10)   NOT NULL,
  PARAM_NAME   VARCHAR2 (100)  NOT NULL,
  PARAM_VALUE  VARCHAR2 (100)  NOT NULL,
  PARAM_DESC   VARCHAR2 (100),
  CONSTRAINT PK_OMALERT_PARAM
  PRIMARY KEY ( PARAM_ID ) ) ;
/

ALTER TABLE OMALERT.OM_ALERT_PARAMETERS ADD  CONSTRAINT UK_OMALERT_PARAM
 UNIQUE (PARAM_NAME) ;
/



GRANT ALTER ON OMALERT.OM_ALERT_PARAMETERS TO PUBLIC;
/

GRANT DELETE ON OMALERT.OM_ALERT_PARAMETERS TO PUBLIC;
/

GRANT INDEX ON OMALERT.OM_ALERT_PARAMETERS TO PUBLIC;
/

GRANT INSERT ON OMALERT.OM_ALERT_PARAMETERS TO PUBLIC;
/

GRANT SELECT ON OMALERT.OM_ALERT_PARAMETERS TO PUBLIC;
/

GRANT UPDATE ON OMALERT.OM_ALERT_PARAMETERS TO PUBLIC;
/

GRANT REFERENCES ON OMALERT.OM_ALERT_PARAMETERS TO PUBLIC;
/




CREATE PUBLIC SYNONYM OM_ALERT_PARAMETERS FOR OMALERT.OM_ALERT_PARAMETERS;
/
