December 2002
Intermediate to advanced
928 pages
85h 29m
English
Materialized Views
Provides privileges to perform operations on materialized views. Materialized views are preaggregated summaries used for business intelligence operations. Materialized views were new in Oracle8i. In Oracle8i, both materialized views and snapshots could have these privileges. For Oracle8 and previous versions, only snapshots could have these privileges.
None.
DELETE, FLASHBACK, INSERT, SELECT, UPDATE. The DELETE, INSERT, and UPDATE privileges can be granted only on updatable materialized views.