Passing the query on the command line works, as does including it in a parfile. I don't know why my first attempts with a parfile failed...probably I fat-fingered something. The problem with a long list of tables turns out to be a known bug, fixed in 10.1.0.4.0 patchset 5 (and presumably in 10gR2). > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On > Behalf Of Paul Baumgartel > Sent: Thursday, September 15, 2005 1:23 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: two questions about expdp > > > . . . > > 2. How to specify a query clause of the form column='literal'? I have > tried various combinations of single quotes, double quotes, and double > single quotes, so far with no luck; expdp returning "SQL command not > properly ended". > > > Privileged/Confidential Information may be contained in this message or > attachments hereto. Please advise immediately if you or your employer do not > consent to Internet email for messages of this kind. Opinions, conclusions > and other information in this message that do not relate to the official > business of this company shall be understood as neither given nor endorsed > by it. > > -- Paul Baumgartel paul.baumgartel@xxxxxxxxxxxx