Oracle Error ORA-33261: (DIMSHOW02) A partition name may be specified only for a partitioned variable.

Oracle Error Message

ORA-33261: (DIMSHOW02) A partition name may be specified only for a partitioned variable.

Reason for the Error

A PARTITION qualification was provided for an object other than a partitioned variable.

Solution

Remove the PARTITION qualification.