RE: EXPDP QUERY format

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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

Other related posts: