Try:

Code:
-- Etc --
 ,start_date => TO_DATE('08/MAY/2009 12:00:00','DD/MM/YYYY HH24:MI:SS')
-- Etc --

PS: Not sure if you need outer single or double or no quotes.