ORA-01793: maximum number of index columns is 32

[dbasan]

Hi, Thanks for the inputs.

I used only 32 columns in the group by clause. It works. If it exceeds more then 32, it is giving error.

Its a known bug, You can over come by "using no index" clause in MV creation if its more than 32 cols.Try...........