December 2002
Intermediate to advanced
928 pages
85h 29m
English
MATERIALIZED VIEW
Provides the ability to work with materialized views. The MATERIALIZED VIEW privileges were known as the SNAPSHOT privileges prior to Oracle8i.
Gives the privilege to create a materialized view that is refreshed on COMMITs. New with Oracle8i.
See the entries for [GLOBAL] QUERY REWRITE and FLASHBACK ANY TABLE under Miscellaneous Privileges.
CREATE [ANY], ALTER ANY, DROP ANY.