Oracle Error ORA-36315: (PHYS04) You must specify the VALUE option for scalar relation workspace object.

Oracle Error Message

ORA-36315: (PHYS04) You must specify the VALUE option for scalar relation workspace object.

Reason for the Error

The VALUE argument to PHYSICAL was omitted for a scalar relation

Solution

specify VALUE or choose a dimensioned relation