DBMS_ADVISOR.TUNE_MVIEW - is the ALTER MATERIALIZED VIEW LOG FORCE statement required?
I'm using the DBMS_ADVISOR.TUNE_MVIEW utility to create a materialized view, and I'm confused about the statements it generates for the materialized view log. The following example is taken from Oracle's SQL Access Advisor 11gR2 documentation (http://docs.oracle.com/cd/E11882_01/server.112/e16638/advisor.htm#i1038234):
CREATE MATERIALIZED VIEW LOG ON "SH"."SALES"
WITH ROWID, SEQUENCE ("PROD_ID","CUST_ID","AMOUNT_SOLD")
INCLUDING NEW VALUES
ALTER MATERIALIZED VIEW LOG FORCE ON "SH"."SALES"
ADD ROWID, SEQUENCE ("PROD_ID","CUST_ID","AMOUNT_SOLD")
INCLUDING NEW VALUES
What's the purpose of the ALTER MATERIALIZED VIEW LOG FORCE statement? It seems to accomplish everything the
0