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.

I will take a look at the Normalization part and see how i can assign multiple block size tablespace for this table. Can please confirm that this problem is due to "Column values in the group by clause exceeds DB_BLOCK_SIZE". I just want to confirm this for my understanding... Thank you so much for the info. This site is very helpful. Once again thank you all