In this post, you’ll learn more about the Oracle ErrorORA-36315: (PHYS04) You must specify the VALUE option for scalar relation workspace object. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-36315: (PHYS04) You must specify the VALUE option for scalar relation workspace object.
Reason for the Error ORA-36315: (PHYS04) You must specify the VALUE option for scalar relation workspace object.
The VALUE argument to PHYSICAL was omitted for a scalar relation
How to fix the Error ORA-36315: (PHYS04) You must specify the VALUE option for scalar relation workspace object. ?
You can fix this error in Oracle by following the below steps
specify VALUE or choose a dimensioned relation