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
33 DBMS_MVIEW → DBMS_MVIEW enables you to understand capabilities for materialized views and potential materialized … : Summary of DBMS_MVIEW Subprograms Note: DBMS_SNAPSHOT is a synonym for DBMS_MVIEW. See Also
15 DBMS_MVIEW → DBMS_MVIEW enables you to understand capabilities for materialized views and potential materialized … : Summary of DBMS_MVIEW Subprograms Note: DBMS_SNAPSHOT is a synonym for DBMS_MVIEW. See Also
Parameters → Table 15-2 BEGIN_TABLE_REORGANIZATION Procedure Parameters Parameter Description tabowner Owner of the table being reorganized. tabname Name of the table being reorganized.
Syntax → The following PL/SQL declarations that are made for you in the DBMS_MVIEW package show the order
REFRESH_ALL_MVIEWS Procedure → This procedure refreshes all materialized views that have the following properties: The materialized view has not been refreshed since the most recent change to a master table or master materialized view on which it depends. The materialized view and all of the master tables or master materialized views on which it depends are local. The materialized view is in the view DBA_MVIEWS. This procedure
BEGIN_TABLE_REORGANIZATION Procedure → This procedure performs a process to preserve materialized view data needed for refresh. It must be called before a master table is reorganized. See Also: "Reorganizing Master Tables that Have Materialized View Logs"
Syntax → DBMS_MVIEW.I_AM_A_REFRESH() RETURN BOOLEAN;
Syntax → You can obtain the output from EXPLAIN_REWRITE in two ways. The first is to use a table, while the second is to create a VARRAY. The following shows the basic syntax for using an output table: DBMS_MVIEW.EXPLAIN_REWRITE ( query IN VARCHAR2, mv IN VARCHAR2, statement_id IN VARCHAR2; If you want to direct the output of EXPLAIN_REWRITE to a varray, instead of a table, then the procedure should be called
Parameters → Table 15-8 PURGE_MVIEW_FROM_LOG Procedure Parameters Parameter Description mview_id If you want to execute this procedure based on the identification of the target materialized view, specify the materialized view identification using the mview_id parameter. Query the DBA_BASE_TABLE_MVIEWS view at the materialized view log site for a listing of materialized view IDs. Executing this procedure based
Usage Notes → This procedure is invoked at the master site or master materialized view site by a remote materialized view site using a remote procedure call. If REGISTER_MVIEW is called multiple times with the same mviewowner, mviewname, and mviewsite, then the most recent values for mview_id, flag, and qry_txt are stored. If a query exceeds the maximum VARCHAR2 size, then qry_txt contains the first 32000 characters
Parameters → None. PMARKER Function This function returns a partition marker from a rowid. It is used for Partition Change Tracking (PCT).
Syntax → DBMS_MVIEW.PURGE_DIRECT_LOAD_LOG();
PURGE_MVIEW_FROM_LOG Procedure → This procedure is called on the master site or master materialized view site to delete the rows in materialized view refresh related data dictionary tables maintained at the master for the specified materialized view identified by its mview_id or the combination of the mviewowner, mviewname, and the mviewsite. If the materialized view specified is the oldest materialized view to have refreshed from
Summary of DBMS_MVIEW Subprograms → Table 15-1 DBMS_MVIEW Package Subprograms Subprogram Description "BEGIN_TABLE_REORGANIZATION
PURGE_DIRECT_LOAD_LOG Procedure → This procedure removes entries from the direct loader log after they are no longer needed for any known materialized view. This procedure usually is used in environments using Oracle's data warehousing technology. See Also: Oracle9i Data Warehousing Guide for more information
Syntax → DBMS_MVIEW.END_TABLE_REORGANIZATION ( tabowner IN VARCHAR2, tabname IN VARCHAR2);
REGISTER_MVIEW Procedure → This procedure enables the administration of individual materialized views. It is invoked at a master site or master materialized view site to register a materialized view. Note: Typically, a materialized view is registered automatically during materialized view creation. You should only run this procedure to manually register a materialized view if the automatic registration failed or if the registration
Syntax → DBMS_MVIEW.PMARKER(rid IN ROWID) RETURN NUMBER;
Parameters → Table 15-13 UNREGISTER_MVIEW Procedure Parameters Parameters Description mviewowner Owner of the materialized view. mviewname Name of the materialized view. mviewsite Name of the materialized view site. Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback
Parameters → Table 15-12 REGISTER_MVIEW Procedure Parameters Parameter Description mviewowner Owner of the materialized view. mviewname Name of the materialized view. mviewsite Name of the materialized view site for a materialized view registering at an Oracle8 and higher master site or master materialized view site. This name should not contain any double quotes. mview_id The identification number of the materialized