Oracle Error ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.

Oracle Error Message

ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.

Reason for the Error

The user attempted to execute ALLOCATE with mismatched TARGET and TARGETLOG variables

Solution

Use TARGET and TARGETLOG variables with matching dimensionality.