SQL> set lines 132 SQL> select * from mv_capabilities_table; STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL PCT N STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- 1 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REFRESH_COMPLETE Y STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- 1002 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REFRESH_FAST Y STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- 2003 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REWRITE N STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- 3004 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL PCT_TABLE N C_BO_PRFL 893 2068 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- relation is not a partitioned table 4005 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REFRESH_FAST_AFTER_INSERT Y STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- 5006 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REFRESH_FAST_AFTER_ONETAB_DML Y STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- 6007 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REFRESH_FAST_AFTER_ANY_DML Y STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- 7008 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REFRESH_FAST_PCT N 2157 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- PCT is not possible on any of the detail tables in the materialized view 8009 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REWRITE_FULL_TEXT_MATCH N C_BO_PRFL 893 2099 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- mv references a remote table or view in the FROM list 9010 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REWRITE_FULL_TEXT_MATCH N 2159 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- query rewrite is disabled on the materialized view 9011 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REWRITE_PARTIAL_TEXT_MATCH N 2031 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- materialized view cannot support any type of query rewrite 10012 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REWRITE_PARTIAL_TEXT_MATCH N 2159 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- query rewrite is disabled on the materialized view 10013 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REWRITE_GENERAL N 2031 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- materialized view cannot support any type of query rewrite 11014 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REWRITE_GENERAL N 2159 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- query rewrite is disabled on the materialized view 11015 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- CIR C_BO_PRFL REWRITE_PCT N 2158 STATEMENT_ID MVOWNER MVNAME CAPABILITY_NAME P ------------------------------ ------------------------------ ------------------------------ ------------------------------ - RELATED_TEXT ------------------------------------------------------------------------------------------------------------------------------------ RELATED_NUM MSGNO ----------- ---------- MSGTXT ------------------------------------------------------------------------------------------------------------------------------------ SEQ ---------- general rewrite is not possible and PCT is not possible on any of the detail tables 12016 16 rows selected. SQL> spool off