datapump exclude partition
From: Steiner, Randy <Randy.Steiner_at_nyct.com>
Date: Fri, 5 Sep 2008 12:09:16 -0400
Message-ID: <D5006AF7251D5046A0A63E39A23148DC0164A1C1@NYCTEXVS07.transit.nyct.com>
Date: Fri, 5 Sep 2008 12:09:16 -0400
Message-ID: <D5006AF7251D5046A0A63E39A23148DC0164A1C1@NYCTEXVS07.transit.nyct.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 05 2008 - 11:09:16 CDT