My Oracle Support Banner

Common Questions On Materialized View Created On Prebuilt Table (Doc ID 1532430.1)

Last updated on AUGUST 26, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.6 and later
Information in this document applies to any platform.

Purpose

The article provides answers to questions often asked about materialized view created on prebuilt table.

Questions and Answers

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
Purpose
Questions and Answers
 How to create materialized view on prebuilt table?
 How long does it take to such a materialized view
 How to drop such a materialized view
 Scenarios when creating materialized view on prebuilt table could be useful
 What are the restrictions on using prebuilt tables
 Can i fast refresh a materialized view created on prebuilt table right after it was created?
 Further examples

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.