Oracle Error ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.

Oracle Error Message

ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.

Reason for the Error

The user specified an invalid source or basis relation on the ALLOCATE command line.

Solution

Modify the relation to be a one-dimensional self-relation.