Oracle Error ORA-36313: (PHYS03) The VALUE option of PHYSICAL cannot be applied to a variable.

Oracle Error Message

ORA-36313: (PHYS03) The VALUE option of PHYSICAL cannot be applied to a variable.

Reason for the Error

the VALUE argument to PHYSICAL was supplied for a variable.

Solution

remove VALUE or specify a relation or dimension.