EXPDP QUERY format

I am trying to export a portion of a large table using the QUERY option of datapump. Here is a listing of the parameter file and the error I receive.

directory=data_pump_dir
dumpfile=in_multiplecode_dw.dmp
logfile=in_multiplecode_dw.log
tables=IN_MUTLIPLECODE
query=in_multiplecode:\"where incidentid in (select incidentid from incidentkey where in_date \> TO_DATE('31-dec-2003','dd-mon-yyyy') and in_date \< TO_DATE('01-jan-2006','dd-mon-yyyy'))\"

SYNTAX error in QUERY at "("
LRM-00116: syntax error at ')' following ''dd-mon-yyyy'' LRM-00113: error when processing file 'in_mc.par'

I have also tried this...
directory=data_pump_dir
dumpfile=in_multiplecode_dw.dmp
logfile=in_multiplecode_dw.log
tables=IN_MUTLIPLECODE
query=in_multiplecode:\"where incidentid in \(select incidentid from incidentkey where in_date \> TO_DATE \(\'31-dec-2003\',\'dd-mon-yyyy\'\) and in_date \< TO_DATE\(\'01-jan-2006\',\'dd-mon-yyyy\'\)\)\"

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39001: invalid argument value
ORA-39035: Data filter SUBQUERY has already been specified.

Does anyone have any idea what characters need the backslash and which don't?

Thanks for your assistance,

Bill--
http://www.freelists.org/webpage/oracle-l Received on Mon Jan 10 2011 - 08:29:03 CST