Re: datapump exclude partition

Check out this OTN Forum entry:
http://forums.oracle.com/forums/message.jspa?messageID=2633043

I also don't see any reference to partitions in schema_export_objects, database_export_objects or table_export_objects.

Bradd Piontek
Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd

On Fri, Sep 5, 2008 at 11:09 AM, Steiner, Randy <Randy.Steiner_at_nyct.com>wrote:

> 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