Re: datapump exclude partition
- From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
- To: Randy.Steiner@xxxxxxxx
- Date: Fri, 5 Sep 2008 12:26:20 -0500
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@xxxxxxxx>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
>
>
>
Other related posts:
