EXPDP QUERY format
- From: Bill Zakrzewski <bill@xxxxxxxxxxxx>
- To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 10 Jan 2011 09:29:03 -0500
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
