Oracle Solution for Error ora-37103

ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object

does not match the dimensionality or datatype of the partition.

What triggered the Error:

User attempted to define a partitioned variable with an external partition, but the target of the external partition had incorrect dimensionality or datatype.

What should we do to fix it:

Pick a different target variable. The target variable must be dimensioned by exactly the same dimensions, composites, and partition templates, in the same order, as are specified in the partition template, and must have the exact same datatype (including width, precision, and scale) as the partitioned variable itself.