Re: Invalid QUERY in impdp
From: Tom Lanyon <tom_at_netspot.com.au>
Date: Sat, 24 Apr 2010 14:54:30 +0930
Message-Id: <9DE784D7-EE64-4BB3-895F-6F720031D1EB_at_netspot.com.au>
On 24/04/2010, at 12:06 PM, K R wrote:
Date: Sat, 24 Apr 2010 14:54:30 +0930
Message-Id: <9DE784D7-EE64-4BB3-895F-6F720031D1EB_at_netspot.com.au>
On 24/04/2010, at 12:06 PM, K R wrote:
> you might check this one
>
> http://www.rampant-books.com/art_nanda_datapump.htm
>
> $ impdp QUERY=CUSTOMERS:“WHERE TOTAL_SPENT > 10"
Thanks, but let me clarify that according to the impdp documentation the syntax I'm using is correct, and similar but less complex queries have worked successfully.
I see no reason for this one to throw an error, unless the QUERY ability of impdp doesn't support inline views or something... ?
Tom--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 24 2010 - 00:24:30 CDT