Skip to Main Content

Oracle Database Discussions

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!

exclude parameter limitations

user511621Sep 28 2010 — edited Sep 29 2010
Hi

is there any limitations for excluding no of objects while doing expdp

when i m excluding 2 table is running

expdp system/**** parfile=q.par
________________________________ q.par__________________________________________________________________________
DIRECTORY=TEST_DIR DUMPFILE=filename.dmp LOGFILE=filename.log SCHEMAS=xyz exclude=TABLE:"IN ('tab1', 'tab2')"
_______________________________________________________________________________________________________________________

when i m excluding 2000 tables expdp is showing below error

Export: Release 11.1.0.6.0 - 64bit Production on Tuesday, 28 September, 2010 17:08:44

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
UDE-00014: invalid value for parameter, 'exclude'.

plz suggest.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2010
Added on Sep 28 2010
8 comments
3,015 views