datapump exclude partition
- From: "Steiner, Randy" <Randy.Steiner@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Sep 2008 12:09:16 -0400
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
Other related posts:
