You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for materialized views


1 to 20 of 5476 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

Validating Tables, Indexes, Clusters, and Materialized ViewsTo verify the integrity of the structure of a table, index, cluster, or materialized view, use the … cluster is corrupt, you should drop it and re-create it. If a materialized view is corrupt, perform … , drop and re-create the materialized view. The following statement analyzes the emp table: ANALYZE

Database Upgrade Guide, 11g Release 2 (11.2)

Behavior Changes After Upgrading Oracle Database

Materialized Views… The new names appear in all data dictionary views, but both the old and new names are accepted by the … GRANT and REVOKE SQL statements. CREATE SNAPSHOT changed to CREATE MATERIALIZED VIEW CREATE ANY … SNAPSHOT changed to CREATE ANY MATERIALIZED VIEW ALTER ANY SNAPSHOT changed to ALTER ANY MATERIALIZED

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Naming Materialized Views, you might consider extending this naming scheme to the materialized views so that they are easily … The name of a materialized view must conform to standard Oracle naming conventions. However, if the … materialized view is based on a user-defined prebuilt table, then the name of the materialized view

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Materialized Views and ModelsExamples of Materialized Views Using UNION ALL The following examples illustrate creation of fast … refreshable materialized views involving UNION ALL. Example 10-5 Materialized View Using UNION ALL … with Two Join Views To create a UNION ALL materialized view with two

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Invalidating Materialized ViewsDependencies related to materialized views are automatically maintained to ensure correct operation … views is not tracked. Thus, if you use remote materialized views for rewrite, they are considered to be trusted. … . When a materialized view is created, the materialized

Database Concepts, 11g Release 2 (11.2)

Partitions, Views, and Other Schema Objects

Characteristics of Materialized Viewsviews Oracle Database SQL Language Reference to learn about the CREATE MATERIALIZED VIEW statement … Characteristics of Materialized Views Materialized views share some characteristics of nonmaterialized … views and indexes. Materialized views

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Creating Materialized ViewsWhy Use Nested Materialized Views? In a data warehouse, you typically create many aggregate views … distinct materialized aggregate views can take a long time, because the underlying join has to be … performed many times. Using nested materialized views, you can create

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Compressing Materialized Viewsforeign keys. In particular, materialized views created with the ROLLUP clause are likely candidates

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Materialized Views with AggregatesIn data warehouses, materialized views normally contain aggregates as shown in Example 9-1. For … Materialized Views with Aggregates\". Fast refresh for a materialized view containing joins and … tables upon which the materialized view is based. Here are some examples of materialized

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

10 Advanced Materialized ViewsThis chapter discusses advanced topics in using materialized views. It contains the following … topics: Partitioning and Materialized Views Materialized Views in Analytic Processing Environments … Materialized Views and Models Invalidating Materialized

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

9 Basic Materialized ViewsThis chapter describes the use of materialized views. It contains the following topics: Overview of … Data Warehousing with Materialized Views Types of Materialized Views Creating Materialized Views … Registering Existing Materialized

Database Concepts, 11g Release 2 (11.2)

Partitions, Views, and Other Schema Objects

Overview of Materialized ViewsMaterialized views are query results that have been stored or \"materialized\" in advance as schema … objects. The FROM clause of the query can name tables, views, and materialized views. Collectively … term). Materialized views are used to summarize,

Database Data Warehousing Guide, 11g Release 2 (11.2)

Maintaining the Data Warehouse

Refreshing Materialized Views… Alternatively, you can control the time when refresh of the materialized views occurs by specifying ON DEMAND … Refresh one or more materialized views. DBMS_MVIEW.REFRESH_ALL_MVIEWS Refresh all materializedviews. DBMS_MVIEW.REFRESH_DEPENDENT Refresh all materialized

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Query Rewrite

Multiple Materialized Views) GROUP BY prod_category; Multiple Materialized Views Que ry rewrite has been extended to enable the … rewrite of a query using multiple materialized views. If query rewrite determines that there is no … set of materialized views that returns all of the data, then query rewrite retrieves

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Registering Existing Materialized ViewsSome data warehouses have implemented materialized views in ordinary user tables. Although this … solution provides the performance benefits of materialized views, it does not: Provide query rewrite to … all SQL applications. Enable materialized views defined in one application to be

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Dropping Materialized ViewsUse the DROP MATERIALIZED VIEW statement to drop a materialized view. For example, consider the … following statement: DROP MATERIALIZED VIEW sales_sum_mv; This statement drops the materialized view … sales_sum_mv. If the materialized view was prebuilt on a table, then the table is not dropped, but it

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Altering Materialized Viewssecurity implications for materialized views accessed in this way are much the same as for indexes: all … . Restrictions with Materialized Views and Virtual Private Database Query rewrite does not use its … you directly specify when you create the materialized view. Altering Materialized

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Types of Materialized ViewsFROM clause of a SELECT statement), subqueries, and materialized views can all be joined or referenced … , such as in the WHERE clause. The types of materialized views are: Materialized Views with Aggregates … Materialized Views Containing Only Joins

Database Data Warehousing Guide, 11g Release 2 (11.2)

Basic Materialized Views

Nested Materialized Viewsview. A nested materialized view can reference other relations in the database in addition to referencing materialized views. … A nested materialized view is a materialized view whose definition is based on another materialized

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Materialized Views

Partitioning and Materialized Views… Partitioning the fact tables also improves the opportunity of fast refreshing the materialized view … because this may enable Partition Change Tracking (PCT) refresh on the materialized view. Partitioning … a materialized view also has benefits for refresh, because the refresh procedure can then use … the materialized