Oracle Error Message
ORA-54642: PARTITION_TABLE utility: invalid SORT_DIMENSION specified
Reason for the Error
An invalid string was specified for the SORT_DIMENSION.
Solution
Specify the SORT_DIMENSION as ‘BEST_DIM’, ‘DIMENSION_1’, ‘DIMENSION_2’, or ‘DIMENSION_3’.