The materialized view will create several objects in the database. The user creating the
materialized view must have the CREATE MATERIALIZED VIEW, CREATE TABLE, and CREATE
VIEW privileges as well as the SELECT privilege on any tables that are referenced but are owned
by another schema. If the materialized view is going to be created in another schema, the user
creating the materialized view must have the CREATE ANY MATERIALIZED VIEW privilege and
the SELECT privilege to the tables that are referenced in the materialized view if the tables are
owned by another schema. To enable query rewrite on a materialized view that references tables
within another schema, the user enabling query rewrite must have the GLOBAL QUERY REWRITE
privilege or be explicitly granted the QUERY REWRITE privilege on any referenced table within
another schema. The user must also have the UNLIMITED TABLESPACE privilege. Materialized
views can be created in the local database, and pull data from the remote master database or
materialized views can reside on the same database server on which the data is located.
If you plan to use the query rewrite feature, you must put the following entry in your
initialization parameter file:
QUERY_REWRITE_ENABLED=TRUE
NOTE
If the OPTIMIZER_FEATURES_ENABLE parameter is set to 10.0.0
or higher, then QUERY_REWRITE_ENABLED defaults to TRUE.
A second parameter, QUERY_REWRITE_INTEGRITY, sets the degree to which Oracle must
enforce query rewriting.
Pages:
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901