-- Oracle does not support `IF NOT EXISTS` syntax when creating indexes.
-- You should review your database for any of the indexes described here that pre-exist,
-- and omit them from what you apply to your Oracle database.

CREATE INDEX IDXZSRMTLEJ61UXHX0YIWPB2RCRV ON BLC_NOTIFICATION_STATE(ACKED, STOPPED, NOTIFICATION_NAME, CHANGE_TIMESTAMP, NEXT_ATTEMPT) ONLINE;