How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Validating Tables, Indexes, Clusters, and Materialized Views → To 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
Materialized Views → Oracle Streams is fully inter-operational with materialized views, or snapshots, which can be used … criterion. There can be multitier materialized views as well, where one materialized view is based … on another materialized view. Materialized views
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
Creating Materialized Views → Views\". Once you have selected the materialized views you want to create, follow these steps for each … materialized view. Design the materialized view. Existing user-defined materialized views do not … A materialized view can be created with the CREATE
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 materialized … views. DBMS_MVIEW.REFRESH_DEPENDENT Refresh all materialized
Materialized Views with Aggregates → In data warehouses, materialized views normally contain aggregates as shown in Example 8-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
Altering Materialized Views → : Oracle Database SQL Language Reference for further information about the ALTER MATERIALIZED VIEW statement and \"Invalidating Materialized Views\" … Six modifications can be made to a materialized view. You can: Change its refresh option ( FAST … are achieved by dropping and then re-creating the materialized
Overview of Materialized Views → Materialized views are schema objects that can be used to summarize, compute, replicate, and … support, and distributed or mobile computing: In data warehouses, materialized views are used to … compute and store aggregated data such as sums and averages. Materialized views in these environments
Refresh Materialized Views → Oracle Database maintains the data in materialized views by refreshing them after changes are made … materialized views that use the fast refresh method, a materialized view log or direct loader log keeps … a record of changes to the master tables. Materialized views
Nested Materialized Views → referencing materialized views. Why Use Nested Materialized Views? In a data warehouse, you typically … ). Incrementally maintaining these distinct materialized aggregate views can take a long time, because the … underlying join has to be performed many times. Using nested materialized
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
Registering Existing Materialized Views → Some 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
Dropping Materialized Views → Use the DROP MATERIALIZED VIEW statement to drop a materialized view. For example. 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 can no
Rolling Materialized Views → scenario. If the fact tables or materialized views include a time dimension and are horizontally … partitioned by the time attribute, then management of rolling materialized views can be reduced to a … at least aligned with, the range partitions. If you plan to have rolling materialized views
Compressing Materialized Views → foreign keys. In particular, materialized views created with the ROLLUP clause are likely candidates
Materialized Views and Models → Models, which provide array-based computations in SQL, can be used in materialized views. Because … the MODEL clause calculations can be expensive, you may want to use two separate materialized views … using one, long materialized view, you could create the following 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
Materialized Views and Snapshots → referred to as materialized views. This section retains the term snapshot. The three interrelated objects
9 Advanced Materialized Views → This 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
8 Basic Materialized Views → This 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