Oracle Missing Comma error on check constraint
It's your regexp_like expression that is invalid. You're using your column as if it was a function name. The syntax is:

regexp_like(thing_to_check, pattern [, options])


You should write:

regexp_like(species_imagefile, '[A-Z0-9._%-]+.JPG', 'i')


'i' is for case-insensitive matching.