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


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

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

I_AM_A_REFRESH FunctionThis function returns the value of the I_AM_REFRESH package state. A return value of TRUE indicates that all local replication triggers for materialized views are effectively disabled in this session because each replication trigger first checks this state. A return value of FALSE indicates that these triggers are enabled.

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

DBMS_MVIEW

SyntaxDBMS_MVIEW.PURGE_MVIEW_FROM_LOG ( mview_id IN BINARY_INTEGER | mviewowner IN VARCHAR2, mviewname IN VARCHAR2, mviewsite IN VARCHAR2); Note: This procedure is overloaded. The mview_id parameter is mutually exclusive with the three remaining parameters: mviewowner, mviewname, and mviewsite.

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

DBMS_MVIEW

UNREGISTER_MVIEW ProcedureThis procedure enables the administration of individual materialized views. It is invoked at a master site or master materialized view site to unregister a materialized view.

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

DBMS_MVIEW

SyntaxDBMS_MVIEW.PURGE_LOG ( master IN VARCHAR2, num IN BINARY_INTEGER:= 1, flag IN VARCHAR2:= 'NOP');

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

DBMS_MVIEW

ParametersTable 15-9 REFRESH Procedure Parameters   Parameter Description list | tab Comma-separated list of materialized views that you want to refresh. (Synonyms are not supported.) These materialized views can be located in different schemas and have different master tables or master materialized views. However, all of the listed materialized views must be in your local database. Alternatively, you may pass

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

DBMS_MVIEW

SyntaxDBMS_MVIEW.REFRESH_DEPENDENT ( number_of_failures OUT BINARY_INTEGER, { list IN VARCHAR2, | tab IN OUT DBMS_UTILITY.UNCL_ARRAY,} method IN VARCHAR2:= NULL, rollback_seg IN VARCHAR2:= NULL, refresh_after_errors IN BOOLEAN:= false, atomic_refresh IN BOOLEAN:= true); Note: This procedure is overloaded. The list and tab parameters are mutually exclusive.

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

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

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

ParametersTable 15-5 EXPLAIN_REWRITE Procedure Parameters Parameter Description query SQL select statement to be explained. mv The fully qualified name of an existing materialized view in the form of SCHEMA.MV statement_id A client-supplied unique identifier to distinguish output messages msg_array The PL/SQL varray that receives the output. Use this parameter to direct EXPLAIN_REWRITE 's output to a PL/SQL

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.REFRESH_ALL_MVIEWS ( number_of_failures OUT BINARY_INTEGER, method IN VARCHAR2:= NULL, rollback_seg IN VARCHAR2:= NULL, refresh_after_errors IN BOOLEAN:= false, atomic_refresh IN BOOLEAN:= true);

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

DBMS_MVIEW

REFRESH_DEPENDENT ProcedureThis procedure refreshes all materialized views that have the following properties: The materialized view depends on a master table or master materialized view in the list of specified masters. 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

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

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

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

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

SyntaxDBMS_MVIEW.UNREGISTER_MVIEW ( mviewowner IN VARCHAR2, mviewname IN VARCHAR2, mviewsite IN VARCHAR2);