Re: datapump exclude partition
- From: "Andrey Goryunov" <goryunov.oracle.l@xxxxxxxxx>
- To: Randy.Steiner@xxxxxxxx
- Date: Tue, 9 Sep 2008 17:36:55 +1000
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@xxxxxxxx>
> 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
Other related posts:
