Oracle Text Option is available in any Oracle Edition.

CREATE INDEX CTX_EVENTHISTORY_00100001

  ON EVENTHISTORY_00100001 (VALUE_STRING)

  INDEXTYPE IS ctxsys.context PARAMETERS ('SYNC ( ON COMMIT)');

SELECT value_string FROM eventhistory WHERE CONTAINS(value_string, 'hello') > 0