Re: Invalid QUERY in impdp
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 24 Apr 2010 12:36:01 -0700 (PDT)
> $ impdp 'scott/tiger' DIRECTORY=DATA_PUMP_DIR \
...
> 'QUERY="WHERE id IN (SELECT id FROM (SELECT id, ROWNUM
> rnum FROM scott.emp ORDER BY id ASC) WHERE rnum >= 85000000 AND
> rnum < 170000000)"'
...
> UDI-00014: invalid value for parameter, 'schemas'
Tom,
It looks like Data Pump does not parse a complicated query. Specifically, when
the query has a select from a subquery, i.e. "... from (select ...", it throws
this error. I reproduced it in 10.2.0.4 and 11.2.0.1. I didn't find anything on
MOS.
For now, you may have to store the result of (SELECT id, ROWNUM rnum FROM
scott.emp ORDER BY id ASC) in a table and query the table when you run data
pump.
Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
