Re: two questions about expdp
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: cstephens16@xxxxxxxxx
- Date: Fri, 16 Sep 2005 10:22:35 -0400
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@xxxxxxxxx> wrote:
>
> 1) TABLES=[schema_name.]table_name[:partition_name] [, ...]
>
> 2)QUERY = [schema.][table_name:] query_clause
>
> On 9/15/05, Paul Baumgartel <paul.baumgartel@xxxxxxxxx> 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@xxxxxxxxxxxx
> >
> >
>
--
Paul Baumgartel
paul.baumgartel@xxxxxxxxxxxx
Other related posts:
