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!

expdp with multiple INCLUDE clauses throwing error

185036Jun 8 2011 — edited Jun 8 2011

I have a parameter file to export few tables from schema PRD as follows:
directory=REF_P04
schemas=PRD
INCLUDE=TABLE:"LIKE'PRD_DATA_%'",:"LIKE'PRD_SI_%'"
dumpfile=prd_call.dmp
logfile=prd_call.log

Number of tables for 'PRD_DATA_%'=78
Number of tables for 'PRD_SI_%'=98

According to document include syntex is : INCLUDE=object_type[:name_clause] [, ...]

So I cannot mention table names in IN clause. I will add more clause to add more tables like this.

I am running the above par file as: expdp system/xxxxxxx parfile=myexp.par

Error I am getting is:
Export: Release 10.2.0.3.0 - 64bit Production on

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39071: Value for INCLUDE is badly formed.
ORA-00907: missing right parenthesis

This post has been answered by clcarter on Jun 8 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2011

Added on Jun 8 2011

#database-key-features, #export-import-sql-loader-external-tables

3 comments

2,383 views