Oracle Solution for Error ora-36710

Solution for Oracle Error ORA-36710

ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object

must be dimensioned identically to TARGET variable workspace object

.

What triggered the Error:

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

What should we do to fix it:

Use TARGET and TARGETLOG variables with matching dimensionality.