EUT is needed for fast
Chapter 17: Managing Distributed Databases 627
-- refresh after partitioned
-- maintenance operations on the table
-- named in the RELATED_NAME column
-- and to do non-stale tolerated
-- rewrite when the mv is partially
-- stale with respect to the table
-- named in the RELATED_NAME column.
-- EUT can also sometimes enable fast
-- refresh of updates to the table
-- named in the RELATED_NAME column
-- when fast refresh from an mv log
-- or change capture table is not
-- possible.
POSSIBLE CHARACTER(1), -- T = capability is possible
-- F = capability is not possible
RELATED_TEXT VARCHAR(2000),-- Owner.table.column, alias name, etc.
-- related to this message. The
-- specific meaning of this column
-- depends on the MSGNO column. See
-- the documentation for
-- DBMS_MVIEW.EXPLAIN_MVIEW() for details
RELATED_NUM NUMBER, -- When there is a numeric value
-- associated with a row, it goes here.
-- The specific meaning of this column
-- depends on the MSGNO column. See
-- the documentation for
-- DBMS_MVIEW.EXPLAIN_MVIEW() for details
MSGNO INTEGER, -- When available, QSM message #
-- explaining why not possible or more
-- details when enabled.
MSGTXT VARCHAR(2000),-- Text associated with MSGNO.
SEQ NUMBER); -- Useful in ORDER BY clause when
-- selecting from this table.
Once the EXPLAIN_MVIEW procedure has been executed, you can query the MV_
CAPABILITIES_TABLE to determine your options:
select Capability_Name, Msgtxt
from MV_CAPABILITIES_TABLE
where Msgtxt is not null;
For the LOCAL_BOOKSHELF materialized view, the query returns the following:
CAPABILITY_NAME
------------------------------
MSGTXT
------------------------------------------------------------
PCT_TABLE
relation is not a partitioned table
REFRESH_FAST_AFTER_INSERT
the detail table does not have a materialized view log
REFRESH_FAST_AFTER_ONETAB_DML
628 Oracle Database 11g DBA Handbook
see the reason why REFRESH_FAST_AFTER_INSERT is disabled
REFRESH_FAST_AFTER_ANY_DML
see the reason why REFRESH_FAST_AFTER_ONETAB_DML is disabled
REFRESH_FAST_PCT
PCT is not possible on any of the detail tables in the
materialized view
REWRITE_FULL_TEXT_MATCH
query rewrite is disabled on the materialized view
REWRITE_PARTIAL_TEXT_MATCH
query rewrite is disabled on the materialized view
REWRITE_GENERAL
query rewrite is disabled on the materialized view
REWRITE_PCT
general rewrite is not possible or PCT is not possible on
any of the detail tables
PCT_TABLE_REWRITE
relation is not a partitioned table
10 rows selected.
Pages:
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924