How to Create and Refresh a Primary Key Materialized View
(Doc ID 1390357.1)
Last updated on NOVEMBER 07, 2023
Applies to:
Oracle Database - Standard Edition - Version 9.2.0.1 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later Information in this document applies to any platform.
Goal
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.
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
