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 DBMS_MVIEW


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


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW, 1 of 2

33 DBMS_MVIEWDBMS_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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

15 DBMS_MVIEWDBMS_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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

ParametersTable 15-2 BEGIN_TABLE_REORGANIZATION Procedure Parameters Parameter Description tabowner Owner of the table being reorganized. tabname Name of the table being reorganized.

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

SyntaxThe following PL/SQL declarations that are made for you in the DBMS_MVIEW package show the order

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

REFRESH_ALL_MVIEWS ProcedureThis 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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

BEGIN_TABLE_REORGANIZATION ProcedureThis 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"

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

SyntaxDBMS_MVIEW.I_AM_A_REFRESH() RETURN BOOLEAN;

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

SyntaxYou 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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

ParametersTable 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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

Usage NotesThis 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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

ParametersNone. PMARKER Function This function returns a partition marker from a rowid. It is used for Partition Change Tracking (PCT).

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

SyntaxDBMS_MVIEW.PURGE_DIRECT_LOAD_LOG();

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

PURGE_MVIEW_FROM_LOG ProcedureThis 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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

Summary of DBMS_MVIEW SubprogramsTable 15-1 DBMS_MVIEW Package Subprograms   Subprogram Description "BEGIN_TABLE_REORGANIZATION

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

PURGE_DIRECT_LOAD_LOG ProcedureThis 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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

SyntaxDBMS_MVIEW.END_TABLE_REORGANIZATION ( tabowner IN VARCHAR2, tabname IN VARCHAR2);

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

REGISTER_MVIEW ProcedureThis 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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

SyntaxDBMS_MVIEW.PMARKER(rid IN ROWID) RETURN NUMBER;

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

ParametersTable 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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_MVIEW

ParametersTable 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