How to fix the Oracle error ORA-36693: (XSRELGID25) INHIERARCHY cannot be specified with the GROUPSET and ROLLUP options of GROUPINGID.?

In this post, you’ll learn more about the Oracle ErrorORA-36693: (XSRELGID25) INHIERARCHY cannot be specified with the GROUPSET and ROLLUP options of GROUPINGID. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

INHIERARCHY option was specified.

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

You can fix this error in Oracle by following the below steps

Remove INHIERARCHY option.