Exporting selective data from a table using data pump

 



Hi, we are trying to export selective data from a table using data pump. We are on 11g R2
we are running the following command to extract the data for the month of FEB from table TRX_MAIN that belongs to APP schema

expdp schemas=APP include=TABLE:"IN ('TRX_MAIN')" query=TRX_MAIN:"where to_char(trx_dt_crt,'MON') ='FEB' " directory=DATA_PUMP_DIR dumpfile=trxfeb2011.dmp logfile=trxfeb2011.log


but we keep getting this error

LRM-00116: syntax error at ')' following 'MON'


any ideas? how can we get around this ?


thanks