I am trying to create a Snapshot:

CREATE MATERIALIZED VIEW COHEN3.DEAL_STATUS_MV
PCTFREE 10
PCTUSED 40
MAXTRANS 255
TABLESPACE TS_COHEN3
NOLOGGING
STORAGE(INITIAL 64K
PCTINCREASE 0)
BUILD IMMEDIATE
REFRESH FORCE
START WITH TO_DATE('03-MAY-2003 08:00 AM','DD-MON-YYYY HH12:MI PM') NEXT SYSDATE + 1 AS SELECT h.loan_id as Deal, s.name as STATUS, h.status_date as STATUS_DATE, h.comments as Comments FROM cohen3.loan_status_history h, cohen3.loan_status s WHERE (h.status_id = s.loan_status_id
)
GROUP BY h.loan_id, s.name, h.status_date, h.comments
/

I get the error:

Batch 2 line 14 column 13 ORA-01450: maximum key length (3166) exceeded.

I know the table from which I am creating the view has a varchar2(4000) comments column so that is creating the error, but I don't know what to do to fix the view if it is possible. This column was used in another view without error???

Any help appreciated!