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/05, Chris Stephens <cstephens16_at_gmail.com> wrote:
>
> 1) TABLES=[schema_name.]table_name[:partition_name] [, ...]
>
> 2)QUERY = [schema.][table_name:] query_clause
>
> On 9/15/05, Paul Baumgartel <paul.baumgartel_at_gmail.com> wrote:
> > 1. In parameter file, would like to specify many (say 100) table names.
> The
> > old exp would accept a list like this in a parameter file:
> > tables=(table1
> > ,table2
> > ,table3
> > ,table4)
> >
> > expdp doesn't require parentheses, so I tried
> > tables=table1
> > ,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
> to
> > get it to work when the list of tables is much smaller, though. Didn't
> find
> > anything on MetaLink. Anyone had experience with this?
> >
> > 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".
> >
> > Thanks in advance,
> >
> >
> > --
> > Paul Baumgartel
> > paul.baumgartel_at_aya.yale.edu
> >
> >
>
--
Paul Baumgartel
paul.baumgartel_at_aya.yale.edu
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 16 2005 - 09:25:17 CDT
