Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UDE-00014 : invalid value for parameter, 'include'.

658578Apr 9 2010 — edited May 25 2011
Hi, I need to do an export of specific tables from a schema and a particular query will be applied to all tables specified in "INCLUDE=TABLE:"IN ('TBL1','TBL2')" in expdp command.

Now I'm getting the issue in this INCLUDE parameter. I have around 200 tables that needs to be included and I'm adding this INCLUDE parameter in a seperate parameter file with all 200 table names in it and using that parameter file in the expdp command.

Error Message that I'm getting :
UDE-00014: invalid value for parameter, 'include'.

when I use the same process for 2 tables it works fine. I guess there is some limit in number of characters that can be used in INCLUDE parameter. If so, then how should I use expdp to select only these 200 tables out of 500 tables in my schema. I would appreciate any help on this. Thanks.
This post has been answered by Dean Gagne-Oracle on Apr 9 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2011
Added on Apr 9 2010
#database-key-features, #export-import-sql-loader-external-tables
7 comments
10,169 views