CREATE MATERIALIZED VIEW COHEN3.DEAL_STATUS_MV
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???