Oracle Solution for Error ora-36714

Solution for Oracle Error ORA-36714

ORA-36714: (XSMXALLOC03) TARGETLOG variable workspace object

must have the same data type as TARGET variable workspace object

.

What triggered the Error:

The user specified a TARGETLOG variable that had a different data type from the TARGET variable.

What should we do to fix it:

Use TARGETLOG and TARGET variables with an identical data type.