Re: two questions about expdp-- answered

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Fri, 16 Sep 2005 17:08:26 -0400
Message-ID: <f8c47710509161408a587d58@mail.gmail.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
> Behalf Of Paul Baumgartel
> Sent: Thursday, September 15, 2005 1:23 PM
> To: oracle-l_at_freelists.org
> 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_at_aya.yale.edu

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 16 2005 - 16:10:40 CDT