Monday, October 28, 2013

How to only export specific partitions using Oracles data pump utility

In your parameter file, use the following notation:

TABLES=SCOTT.TABLE1:PART_1

You can export more partitions in the same run:

TABLES=SCOTT.TABLE1:PART_1,
TABLES=SCOTT.TABLE2:PART_3,
TABLES=SCOTT.TABLE2:PART_4


Note that you may not export data from multiple schema in this mode, in other words, the notation:

TABLES=SCOTT.TABLE1:PART_1,
TABLES=HR.TABLE1:PART_1

will throw an error:

UDE-00012: table mode exports only allow objects from one schema

No comments:

Post a Comment