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