Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> two questions about expdp

two questions about expdp

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Thu, 15 Sep 2005 16:22:59 -0400
Message-ID: <f8c477105091513226738c921@mail.gmail.com>

  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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 15 2005 - 15:25:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US