FAQ
Hi Randy,

looks like you can only exclude it using tables clause (avoiding it in a
list):

expdp directory=e dumpfile=t1.dmp logfile=t1.log
tables=AG.TEST1:P1,AG.TEST1:P2

where of course tables and partitions can be put to parameter file that can
be easily generated using sqlplus

Regards
Andrey

2008/9/6 Steiner, Randy
I would like to do an export with datapump that would exclude just one
partition of a table.

Here is my par file:



parallel = 1

dumpfile = BK:fulln1_%U.dat

filesize = 2g

logfile = LOGS:export.log

FULL=y

EXCLUDE=TABLE:"IN ('TBL:PART1','TBL2', 'TBL3')"


TBL2 and TBL3 are excluded, but TBL.PART1 is not.



No errors are being generated.



Db is 10.2.0.4 running on rhel3



Thanks

Randy

--
Regards,
Andrey Goryunov

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 3 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 5, '08 at 4:09p
activeSep 9, '08 at 7:36a
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase