Oracle 9.2.0.6.0 - 64bit on Sun Solaris
Has anyone managed to create a materialized view with index organization ? I have an MV which only has one column, so I wanted it to be index organized, but I'm really struggling with the syntax for it. My latest attempt is:
Whatever I try, I get ORA-905, missing keyword. Unfortunately, it gives me no clue as to which keyword is missing and the manual is none too helpful.Code:create materialized view mv_annuity_tcns using index refresh on demand organization index pctthreshold 90 including annuitytcn overflow tablespace sml_d as SELECT DISTINCT TRIM(COLUMN_72) ANNUITYTCN FROM SRC_FEED_DATA WHERE SRC_SYS_FEED_ID = 666 and TRIM(COLUMN_72) IS NOT NULL




Reply With Quote