How to Create and Refresh a Primary Key Materialized View
(Doc ID 1390357.1)
Last updated on AUGUST 04, 2018
Oracle Database - Standard Edition - Version 220.127.116.11 to 18.104.22.168 [Release 9.2 to 11.2]
Information in this document applies to any platform.
This document has been created to
- Provide some materialized view basics
- Give a simple and straight-forward example for creating a distributed, read-only materialized view based on the PRIMARY KEY option -- just enough to get you started.
- Show an example of how to run a refresh of this mview.
If you are interested only in the basic syntax and not in any basic concept information, you can skip down to the syntax section.
Notes: The terms "materialized view" and "mview" are used interchangeably in this document.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.