Oracle Error ORA-36693: (XSRELGID25) INHIERARCHY cannot be specified with the GROUPSET and ROLLUP options of GROUPINGID.

Oracle Error Message

ORA-36693: (XSRELGID25) INHIERARCHY cannot be specified with the GROUPSET and ROLLUP options of GROUPINGID.

Reason for the Error

INHIERARCHY option was specified.

Solution

Remove INHIERARCHY option.