


DROP TABLE OMALERT.OM_ALERT_TEXT CASCADE CONSTRAINTS ;
/
CREATE TABLE OMALERT.OM_ALERT_TEXT (
  TEXT_ID          NUMBER (10)   NOT NULL,
  TEXT_TITLE       VARCHAR2 (100)  NOT NULL,
  TEXT_BODY        VARCHAR2 (800)  NOT NULL,
  TEXT_TABLE_NAME  VARCHAR2 (100),
  CONSTRAINT OM_ALERT_TXT_PK
  PRIMARY KEY ( TEXT_ID ) ) ;
/

GRANT ALTER ON OMALERT.OM_ALERT_TEXT TO PUBLIC;
/

GRANT DELETE ON OMALERT.OM_ALERT_TEXT TO PUBLIC;
/

GRANT INDEX ON OMALERT.OM_ALERT_TEXT TO PUBLIC;
/

GRANT INSERT ON OMALERT.OM_ALERT_TEXT TO PUBLIC;
/

GRANT SELECT ON OMALERT.OM_ALERT_TEXT TO PUBLIC;
/

GRANT UPDATE ON OMALERT.OM_ALERT_TEXT TO PUBLIC;
/

GRANT REFERENCES ON OMALERT.OM_ALERT_TEXT TO PUBLIC;
/




CREATE PUBLIC SYNONYM OM_ALERT_TEXT FOR OMALERT.OM_ALERT_TEXT;
/
