Re: datapump exclude partition

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 <Randy.Steiner_at_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
>
>
>

-- 
Regards,
Andrey Goryunov

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