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 NULLWhatever 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.