RE: EXPDP QUERY format

From: <Joel.Patterson_at_crowley.com>
Date: Mon, 10 Jan 2011 10:04:24 -0500
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA160114F6C9_at_JAXMSG01.crowley.com>


Do you really need to escape these characters inside a parameter file?

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bill Zakrzewski Sent: Monday, January 10, 2011 9:29 AM
To: oracle-l-freelists
Subject: EXPDP QUERY format

Oracle 10.2.0.4.0
Linux RH 5

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 10 2011 - 09:04:24 CST

Original text of this message