Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Name

CREATE/ALTER/DROP MATERIALIZED VIEW

Synopsis

CREATE Syntax:

CREATE MATERIALIZED VIEW [schema.]materialized_view_name
[Physical_Attributes_Clause]
[TABLESPACE tablespace_name]   
[Storage_Clause]
[REFRESH [FAST | COMPLETE | FORCE]
  [START WITH date] [NEXTREF date]]
AS materialized_view_query

ALTER syntax:

ALTER MATERIALIZED VIEW [schema.]materialized_view_name
[Physical_Attributes_Clause]
[Storage_Clause]
[REFRESH [FAST | COMPLETE | FORCE][START WITH date][NEXTREF date]

DROP Syntax:

DROP MATERIALIZED VIEW [schema.]materialized_view_name

Creates, modifies, or removes a materialized view (also called a snapshot), which is the result of a query run against one or more tables or views. The script dbmssnap.sql must be run by SYS before you attempt to create a materialized view. New with Oracle8i.

Keywords

materialized_view_name

Name of the materialized view. Because Oracle appends 7-character identifiers to the name when creating materialized view objects in the schema, you should limit the materialized_view_name to 27 characters or fewer.

TABLESPACE

Specifies the name of the tablespace in which this materialized view will be created. The default tablespace for the schema owner is the default.

REFRESH

Specifies the mode and times for automatic refreshes.

FAST

Use the materialized view log associated with the master table.

COMPLETE

Refresh by reexecuting the materialized view’s query.

FORCE

Oracle will decide if a FAST refresh is possible and, if not, will do a COMPLETE refresh. FORCE is the ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page