DROP SEQUENCE OMALERT.OM_ALERT_COLUMN_SEQ ;
DROP SEQUENCE OMALERT.OM_ALERT_PARAM_SEQ ;
DROP SEQUENCE OMALERT.OM_ALERT_SENDER_SEQ ;
DROP SEQUENCE OMALERT.OM_ALERT_TABLE_SEQ ;
DROP SEQUENCE OMALERT.OM_ALERT_TEXT_SEQ ;
DROP SEQUENCE OMALERT.OM_ALERT_TEXT_VAR_SEQ ;
DROP SEQUENCE OMALERT.OM_ALERT_TRIGGER_SEQ ;
CREATE SEQUENCE OMALERT.OM_ALERT_COLUMN_SEQ INCREMENT BY 1 START WITH 1 MAXVALUE 9999999999 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE OMALERT.OM_ALERT_PARAM_SEQ INCREMENT BY 1 START WITH 1 MAXVALUE 9999999999 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE OMALERT.OM_ALERT_SENDER_SEQ INCREMENT BY 1 START WITH 1 MAXVALUE 9999999999 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE OMALERT.OM_ALERT_TABLE_SEQ INCREMENT BY 1 START WITH 1 MAXVALUE 9999999999 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE OMALERT.OM_ALERT_TEXT_SEQ INCREMENT BY 1 START WITH 1 MAXVALUE 9999999999 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE OMALERT.OM_ALERT_TEXT_VAR_SEQ INCREMENT BY 1 START WITH 1 MAXVALUE 9999999999 NOCYCLE NOCACHE NOORDER;
CREATE SEQUENCE OMALERT.OM_ALERT_TRIGGER_SEQ INCREMENT BY 1 START WITH 1 MAXVALUE 9999999999 NOCYCLE NOCACHE NOORDER;
GRANT SELECT ON OMALERT.OM_ALERT_COLUMN_SEQ TO PUBLIC;
GRANT SELECT ON OMALERT.OM_ALERT_PARAM_SEQ TO PUBLIC;
GRANT SELECT ON OMALERT.OM_ALERT_SENDER_SEQ TO PUBLIC;
GRANT SELECT ON OMALERT.OM_ALERT_TABLE_SEQ TO PUBLIC;
GRANT SELECT ON OMALERT.OM_ALERT_TEXT_SEQ TO PUBLIC;
GRANT SELECT ON OMALERT.OM_ALERT_TEXT_VAR_SEQ TO PUBLIC;
GRANT SELECT ON OMALERT.OM_ALERT_TRIGGER_SEQ TO PUBLIC;
