From oracle-l-bounce@freelists.org Fri Sep 16 09:25:17 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8GEPHUA009082 for ; Fri, 16 Sep 2005 09:25:17 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8GEPC6H009061 for ; Fri, 16 Sep 2005 09:25:13 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CCF1A1ED9A6; Fri, 16 Sep 2005 09:24:28 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21279-07; Fri, 16 Sep 2005 09:24:28 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4BE391ED0C1; Fri, 16 Sep 2005 09:24:28 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=SWIoMXOCsbtPkrQ4ELruoogR36NfFTAfD0nBVaDuf9nO38YILOgIBalmSSXBqUEkUMAMMmOBLJhT+d4fVr8aYqNVyhG1hxzKLFPEwXYqkL5ZZld3PCTqoMjz51z06g/7CJb+d5U05bY6MA2dCWeuuC2Jn97TDpmIilCje0ReFwI= Message-ID: Date: Fri, 16 Sep 2005 10:22:35 -0400 From: Paul Baumgartel To: cstephens16@gmail.com Subject: Re: two questions about expdp Cc: "oracle-l@freelists.org" In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_12058_26974450.1126880555428" References: X-archive-position: 25580 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: paul.baumgartel@gmail.com Precedence: normal Reply-To: paul.baumgartel@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_12058_26974450.1126880555428 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yes, I'm aware of the syntax, and it works fine with a couple of tables.=20 What if you want to specify 100 tables? That's where I'm having trouble. On 9/15/05, Chris Stephens wrote: >=20 > 1) TABLES=3D[schema_name.]table_name[:partition_name] [, ...] >=20 > 2)QUERY =3D [schema.][table_name:] query_clause >=20 > On 9/15/05, Paul Baumgartel wrote: > > 1. In parameter file, would like to specify many (say 100) table names.= =20 > The > > old exp would accept a list like this in a parameter file: > > tables=3D(table1 > > ,table2 > > ,table3 > > ,table4) > > > > expdp doesn't require parentheses, so I tried > > tables=3Dtable1 > > ,table2 > > ,table3 > > > > but expdp returns > > > > ORA-39001: invalid argument value > > ORA-39071: Value for NAME_EXPR filter is badly formed. > > ORA-01756: quoted string not properly terminated > > > > Tried putting all table names on a single line, same result. I am able= =20 > to > > get it to work when the list of tables is much smaller, though. Didn't= =20 > find > > anything on MetaLink. Anyone had experience with this? > > > > 2. How to specify a query clause of the form column=3D'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". > > > > Thanks in advance, > > > > > > -- > > Paul Baumgartel > > paul.baumgartel@aya.yale.edu > > > > >=20 --=20 Paul Baumgartel paul.baumgartel@aya.yale.edu ------=_Part_12058_26974450.1126880555428 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yes, I'm aware of the syntax, and it works fine with a couple of tables.  What if you want to specify 100 tables?  That's where I'm having trouble.

On 9/15/0= 5, Chris Stephens <cstephens16@gmail.com> wrote: 1) TABLES=3D[schema_name.]table_name[:partition_name] [, ...]

2)QUER= Y =3D [schema.][table_name:] query_clause

On 9/15/05, Paul Baumgarte= l <paul.baumgartel@gmail.co= m > wrote:
> 1. In parameter file, would like to specify many (say 1= 00) table names.  The
> old exp would accept a list like th= is in a parameter file:
>  tables=3D(table1
> &n= bsp;,table2
>  ,table3
>  ,table4)
>
>  expdp doesn't requi= re parentheses, so I tried
>  tables=3Dtable1
> =  ,table2
>  ,table3
>
>  but exp= dp returns
>
>  ORA-39001: invalid argument value
>  ORA-39071: Value for NAME_EXPR filter is badly formed.<= br>>  ORA-01756: quoted string not properly terminated
>=
>  Tried putting all table names on a single line, same re= sult.  I am able to
> get it to work when the list of table= s is much smaller, though.  Didn't find
> anything on MetaLink.  Anyone had experience with this?<= br>>
>  2.  How to specify a query clause of t= he form column=3D'literal'?   I have
> tried various combin= ations of single quotes, double quotes, and double
> single quotes, so far with no luck; expdp returning "SQL comm= and not
> properly ended".
>
>  Thanks in = advance,
>
>
> --
> Paul Baumgartel
> paul.baumgartel@aya.yale.edu
>
>

=

--
Paul Baumgartel
paul.baumgartel@aya.yale.edu

------=_Part_12058_26974450.1126880555428-- -- http://www.freelists.org/webpage/oracle-l