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>


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-l
Received on Fri Sep 05 2008 - 11:09:16 CDT

Original text of this message