Materialized View with Index Organization
Oracle 220.127.116.11.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.
create materialized view mv_annuity_tcns using index refresh on demand
organization index pctthreshold 90 including annuitytcn overflow tablespace sml_d
WHERE SRC_SYS_FEED_ID = 666
and TRIM(COLUMN_72) IS NOT NULL